On 04/08/2016 08:31 AM, Michael Nolan wrote:
I'm looking at the possibility of using JSON as a data exchange format
with some apps running on both PCs and Macs. .
The table I would be exporting has a lot of NULL values in it. Is
there any way to skip the NULL values in the row_to_json function and
include only the fields that are non-null?
I guess it depends on your data.
Are the NULLs all in one field or scattered across fields?
Imagining this scenario:
fld_1 fld_2 fld_3
'val1_1' NULL 'val1_3
NULL 'val2_2' 'val2_3'
'val3_3' 'val3_2' NULL
How do you deal with the holes(NULL) on the receiving end?
--
Mike Nolan
no...@tssi.com
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
