Re: json accessors

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: json accessors
Date: 2012-12-05 17:29:58
Message-ID: 98EAA76F-8B80-413E-9A5A-DA5B395E3F85@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Dec 5, 2012, at 9:21 AM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:

>> For sufficiently large columns, I expect I would want a GIN index to speed JSON value extraction queries. Possible with this 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-12-05 17:30:25 Re: PITR potentially broken in 9.2
Previous Message Andres Freund 2012-12-05 17:27:47 Re: Dumping an Extension's Script