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

Re: JSON for PG 9.2

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, "David E(dot) Wheeler" <david(at)kineticode(dot)com>, Claes Jakobsson <claes(at)surfar(dot)nu>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Jan Urbański <wulczer(at)wulczer(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Joey Adams <joeyadams3(dot)14159(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>, Jan Wieck <janwieck(at)yahoo(dot)com>
Subject: Re: JSON for PG 9.2
Date: 2012-01-12 00:53:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

On 01/11/2012 10:21 AM, Pavel Stehule wrote:
> 2012/1/11 Robert Haas<robertmhaas(at)gmail(dot)com>:
>> On Wed, Jan 11, 2012 at 9:41 AM, Pavel Stehule<pavel(dot)stehule(at)gmail(dot)com>  wrote:
>>> I understand it now. My opinion is so some operators and index search
>>> can be in 9.2 - so use a JSON just as communication format now.
>>> * we need to build JSON
>>> * we need to check if some is valid JSON
>>> * we need to store JSON
>>> other steps should be (9.2)
>>> * basic operators eq, neeq
>>> * some tool like XQuery - simple query on JSON document available from
>>> SQL that can be used for functional indexes.
>> That would be nice, but let's not let the perfect be the enemy of the
>> good.  We don't have a lot of time here.
> sorry - replace 9.2 by 9.3 - I am sorry
> I am able to write array_to_json fce and Andrew can write query_to_json

For those who want to play along, see 
<> which has Robert's patch and my 
additions to it.

I'm actually half way through writing an array_to_json function, since 
it it necessary anyway for query_to_json. I hope to have a fairly 
complete working function in about 24 hours.



In response to


pgsql-hackers by date

Next:From: Andrew HammondDate: 2012-01-12 00:57:34
Subject: order of operations for pg_restore
Previous:From: Tom LaneDate: 2012-01-12 00:43:02
Subject: Re: Remembering bug #6123

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