Re: JSON for PG 9.2 - Mailing list pgsql-hackers

From Robert Haas
Subject Re: JSON for PG 9.2
Date
Msg-id CA+TgmoYSGKmXyO4Cnu06D-VYDdihpsFsG+6Zh07zJgRPgke3iw@mail.gmail.com
Whole thread Raw
In response to Re: JSON for PG 9.2  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: JSON for PG 9.2  (Magnus Hagander <magnus@hagander.net>)
Re: JSON for PG 9.2  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Mon, Dec 19, 2011 at 6:26 PM, David E. Wheeler <david@kineticode.com> wrote:
> +1, though I think the core type will at least need some basic operators and indexing support.

And I'm willing to do that, but I thought it best to submit a bare
bones patch first, in the hopes of minimizing the number of
objectionable things therein.  For example, if you want to be able to
index a JSON column, you have to decide on some collation order that
is consistent with JSON's notion of equality, and it's not obvious
what is most logical.  Heck, equality itself isn't 100% obvious.  If
there's adequate support for including JSON in core, and nobody
objects to my implementation, then I'll throw some ideas for those
things up against the wall and see what sticks.

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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: RangeVarGetRelid()
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Fix ScalarArrayOpExpr estimation for GIN indexes