Re: row_to_json() Bug

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: pgsql-hackers Hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: row_to_json() Bug
Date: 2012-02-24 04:49:19
Message-ID: 4F4716CF.6070402@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2012-02-24 04:53:34 Re: foreign key locks, 2nd attempt
Previous Message Joachim Wieland 2012-02-24 04:37:37 Re: patch for parallel pg_dump