Postgres Pro
Downloads
Home   >   mailing lists

Bypassing NULL elements in row_to_json function - Mailing list pgsql-general

From Michael Nolan
Subject Bypassing NULL elements in row_to_json function
Date
Msg-id CAOzAquLGKEBDBKajAdVo7uMC0R52facO3A1f6QNn6h=mNR-6Cw@mail.gmail.com
Whole thread Raw
Responses Re: Bypassing NULL elements in row_to_json function
Re: Bypassing NULL elements in row_to_json function
List pgsql-general
Tree view 
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?
--
Mike Nolan
nolan@tssi.com

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Transitioning to a SQL db
Next
From: Scott Ribe
Date:
Subject: recover from this error