Here's another, quicker way to do it.

SELECT column1,
       column2,
       COALESCE(maybe_null_column, 'NULL')
  FROM your_table; 

Note: If maybe_null_column is not a character data type,
      then you need to coerce it. ie: maybe_null_column::text

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to