On 01/11/2012 10:21 AM, Pavel Stehule wrote:
2012/1/11 Robert Haas<robertmh...@gmail.com>:
On Wed, Jan 11, 2012 at 9:41 AM, Pavel Stehule<pavel.steh...@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.

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 <https://bitbucket.org/adunstan/pgdevel> 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.

cheers

andrew


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to