Re: generating json without nulls - Mailing list pgsql-sql
That's not going to work. I want the row, I just don't want the values that are null.
Tim
Tim
On 07/05/2015 16:16, Andreas Joseph Krogh wrote:
På torsdag 07. mai 2015 kl. 12:56:42, skrev Tim Dudgeon <tdudgeon.ml@gmail.com>:Hi All!
I'm using the postgres json functions to generate json for values in a
table.
Something like this:
SELECT row_to_json(a_table) FROM a_table
But my data has lots of null values and that results in json attributes
like this:
"colname":null
I want to exclude those values from the json and only include non-null
values.
Any idea how to best go about this?
TimWHERE colname IS NOT NULL ?--Andreas Joseph KroghCTO / Partner - Visena ASMobile: +47 909 56 963
