Re: row_to_json() Bug - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: row_to_json() Bug
Date
Msg-id 4F4716CF.6070402@dunslane.net
Whole thread Raw
In response to Re: row_to_json() Bug  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: row_to_json() Bug  ("David E. Wheeler" <david@justatheory.com>)
List pgsql-hackers

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


pgsql-hackers by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: patch for parallel pg_dump
Next
From: Noah Misch
Date:
Subject: Re: foreign key locks, 2nd attempt