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