Postgres Pro
Downloads
Home   >   mailing lists

how to return field based on field= NULL or not - Mailing list pgsql-general

From Juan Backson
Subject how to return field based on field= NULL or not
Date
Msg-id 27c25bc40908232036k3e48f3d8j151010d54f7530ce@mail.gmail.com
Whole thread Raw
Responses Re: how to return field based on field= NULL or not
Re: how to return field based on field= NULL or not
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Getting listed on "Community Guide to PostgreSQL GUI Tools"
Next
From: Adam Rich
Date:
Subject: Re: how to return field based on field= NULL or not