Re: generating json without nulls - Mailing list pgsql-sql
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?
Tim
WHERE colname IS NOT NULL ?
-- 
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963