Horton

Re: JSON for PG 9.2

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: "David E. Wheeler" <david@kineticode.com>, Claes Jakobsson <claes@surfar.nu>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Merlin Moncure <mmoncure@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, Magnus Hagander <magnus@hagander.net>, Jan Urbański <wulczer@wulczer.org>, Simon Riggs <simon@2ndquadrant.com>, Joey Adams <joeyadams3.14159@gmail.com>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>, Jan Wieck <janwieck@yahoo.com>
Date: 2012-01-11T15:15:39Z
Lists: pgsql-hackers 
On Wed, Jan 11, 2012 at 9:41 AM, Pavel Stehule <pavel.stehule@gmail.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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company