Horton

Re: JSON for PG 9.2

Jeff Janes <jeff.janes@gmail.com>

View thread
From: Jeff Janes <jeff.janes@gmail.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Joey Adams <joeyadams3.14159@gmail.com>, Robert Haas <robertmhaas@gmail.com>, "David E. Wheeler" <david@kineticode.com>, Claes Jakobsson <claes@surfar.nu>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Merlin Moncure <mmoncure@gmail.com>, Magnus Hagander <magnus@hagander.net>, Jan Urbański <wulczer@wulczer.org>, Simon Riggs <simon@2ndquadrant.com>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>, Jan Wieck <janwieck@yahoo.com>
Date: 2012-01-22T04:40:30Z
Lists: pgsql-hackers 
On Sun, Jan 15, 2012 at 8:08 AM, Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> On 01/14/2012 03:06 PM, Andrew Dunstan wrote:
>>
>>
>>
>>
>> OK, here's a patch that does both query_to_json and array_to_json, along
>> with docs and regression tests. It include Robert's original patch, although
>> I can produce a differential patch if required. It can also be pulled from
>> <https://bitbucket.org/adunstan/pgdevel>
>>
>>
>
>
> Here's an update that adds row_to_json, plus a bit more cleanup.

This is bit-rotted such that initdb fails

creating template1 database in
/tmp/bar/src/test/regress/./tmp_check/data/base/1 ... FATAL:  could
not create unique index "pg_proc_oid_index"
DETAIL:  Key (oid)=(3145) is duplicated.

I bumped up those oids in the patch, and it passes make check once I
figure out how to get the test run under UTF-8.  Is it supposed to
pass under other encodings?  I can't tell from the rest of thread
whether it supposed to pass in other encodings or not.

Cheers,

Jeff