Re: json accessors - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: json accessors
Date
Msg-id 98EAA76F-8B80-413E-9A5A-DA5B395E3F85@justatheory.com
Whole thread Raw
In response to Re: json accessors  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: json accessors
List pgsql-hackers
On Dec 5, 2012, at 9:21 AM, Andrew Dunstan <andrew@dunslane.net> wrote:

>> For sufficiently large columns, I expect I would want a GIN index to speed JSON value extraction queries. Possible
withthis proposal? 
>
> Probably not.

That greatly reduces its utility for querying, though not, of course, for using it in procedural code.

Wouldn't using a jsonpath-style implementation allow for indexing?

Best,

David


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Dumping an Extension's Script
Next
From: Heikki Linnakangas
Date:
Subject: Re: Dumping an Extension's Script