Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Italy
    Posts
    36

    Unanswered: PostgreSQL query with pipes

    when i do a query with pipes || and one field is null the result is empty
    is there someone who can help me?

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    pipes

    If you want to get out something like that

    Name: Ewald
    Name: Hugo


    SELECT 'Name: ' || name FROM name;

    No record no string 'Name: '
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •