row_to_json() Bug

On 02/23/2012 08:35 PM, David E. Wheeler wrote:

Looks like row_to_json() thinks 0s are nulls:

postgres=# select row(0);
row
-----
(0)
(1 row)

postgres=# SELECT row_to_json(row(0));
row_to_json
-------------
{"f1":null}
(1 row)

Yeah, ouch, will fix.

cheers

andrew

On 02/23/2012 09:09 PM, Andrew Dunstan wrote:

On 02/23/2012 08:35 PM, David E. Wheeler wrote:

Looks like row_to_json() thinks 0s are nulls:

postgres=# select row(0);
row
-----
(0)
(1 row)

postgres=# SELECT row_to_json(row(0));
row_to_json
-------------
{"f1":null}
(1 row)

Yeah, ouch, will fix.

Fixed, Thanks for the report. (Also fixed in my 9.1 backport).

cheers

andrew

On Feb 23, 2012, at 8:49 PM, Andrew Dunstan wrote:

Fixed, Thanks for the report. (Also fixed in my 9.1 backport).

Awesome, thanks, will try it tomorrow.

David