Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group