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