Re: How to pickup null values in SQL Language? - Mailing list pgsql-general

On Thu, 30 May 2002, Tahira Aslam wrote:

>  Select Coalesce(cast(MyView."Document_ID" as
> Text)||','||cast(MyView."First_Name" as
> Text)||','||cast(MyView."Last_Name" as
> Text)||','||cast(MyView."Sent_Date" as Text),'NONE') From "MyView"
> Where "Document_ID"=$1;

If you want a part of the string to become NONE if null, you need
to coalesce each part (I'm dropping the casts for now):
select coalesce(MyView."Document_ID", 'None') || ',' ||
 coalesce(MyView."First_Name", 'None') || ...