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) Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers