| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: generating json without nulls |
| Date: | 2015-05-07 15:16:19 |
| Message-ID: | VisenaEmail.70.7125f92dc9db25c2.14d2ef26624@tc7-visena |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
På torsdag 07. mai 2015 kl. 12:56:42, skrev Tim Dudgeon <tdudgeon(dot)ml(at)gmail(dot)com
<mailto:tdudgeon(dot)ml(at)gmail(dot)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 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com> <https://www.visena.com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Dudgeon | 2015-05-07 15:29:04 | Re: generating json without nulls |
| Previous Message | Tim Dudgeon | 2015-05-07 10:56:42 | generating json without nulls |