That's not going to work. I want the row, I just don't want the values that are null.
Tim
On 07/05/2015 16:16, Andreas Joseph Krogh wrote:
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