On Sun, Aug 23, 2009 at 11:43 PM, Juan Backson<juanback...@gmail.com> wrote: > Hi, > > Thank you for your help. > > What I want to dos is as follows: > > SELECT COALESCE(fieldA::text,fieldB||fieldC||fieldD) from ring where > group_id = 1 > > if fieldB is NULL, i will want it to return fieldC|| fieldD > if fieldB and fieldC is null, I want it to return fieldD. > > Basically, fieldD is always going to have data, but fieldB and fieldC can be > NULL. > > How can I revise the query to meet that purpose?
Just coalesce them all to '' and cat them: ... coalesce(a,'')||coalesce(b,'')||coalesce(c,'')||d ... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
