Re: JSON for PG 9.2

David Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Magnus Hagander <magnus@hagander.net>, Jan Urbański <wulczer@wulczer.org>, Simon Riggs <simon@2ndquadrant.com>, Joey Adams <joeyadams3.14159@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, Bruce Momjian <bruce@momjian.us>, Claes Jakobsson <claes@gluefinance.com>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>, Jan Wieck <janwieck@yahoo.com>

Date: 2011-12-21T02:04:29Z

Lists: pgsql-hackers

On Dec 19, 2011, at 9:00 PM, Robert Haas 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.

+1 Sounds good to me.

David