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? Thanks, JB On Mon, Aug 24, 2009 at 11:55 AM, Wojtek <f...@twine.pl> wrote: > Hi, > > I assume one field will always be NULL and one will always has data in it. > > select coalesce(fieldA, fieldB) from table > > Regards, > foo > > > Juan Backson wrote: > >> Hi, >> >> In my table, I have fieldA and fieldB. At any point in time, only one of >> these fields can have data in it. The other is NULL. >> >> Instead of "select fieldA, fieldB from table", I want it to return either >> fieldA or fieldB depends on whether it is NULL or not. >> >> The reason is because I want to use "select >> array_to_string(array_accum(field A or field B) ,',') from table. >> >> Is it possible to do it that way? >> >> Thanks, >> JB >> > >
