coalesce function

From: itishree sukla <itishree(dot)sukla(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: coalesce function
Date: 2013-06-20 16:15:02
Message-ID: CAL-g6VS4tJOQ74buV_LOBLj31GyXXq-CM_yfUVKRz9niJa=c-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I am using coalesce(firstname,lastname), to get the result if first name is
'NULL' it will give me lastname or either way. I am having data like
instead of NULL, blank null ( i mean something like '' ) for which
coalesce is not working, is there any workaround or other function
available in postgresql, please do let me know.

Regards,
Itishree

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Serge Fonville 2013-06-20 16:26:18 Re: coalesce function
Previous Message salah jubeh 2013-06-20 15:58:35 Replication with Drop: could not open relation with OID