From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: json accessors |
Date: | 2012-12-05 19:52:31 |
Message-ID: | CAHyXU0zNtWbFdLDwDc_-7=dbRvTRNDtRvogQEO0hFWEfznzCRQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Dec 5, 2012 at 12:42 PM, David E. Wheeler <david(at)justatheory(dot)com> wrote:
> On Dec 5, 2012, at 9:57 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>
>> Indexing large documents for fancy querying is a niche case but also
>> quite complex. This isn't very well covered by xmlpath either btw --
>> I think for inspiration we should be looking at hstore.
>
> Agreed, although hstore, IIRC, does not support nesting.
>
>> That said, how would you do that? The first thing that jumps into my
>> mind is to cut right to the chase: Maybe the semantics could be
>> defined so that implement hackstack @> needle would reasonable cover
>> most cases.
>
> Yes.
>
>> So my takeaways are:
>> *) decomposition != precise searching. andrew's api handles the
>> former and stands on it's own merits.
>
> Agreed.
>
>> *) xmlpath/jsonpath do searching (and decomposition) but are very
>> clunky from sql perspective and probably absolutely nogo in terms if
>> GIST/GIN. postgres spiritually wants to do things via operators and
>> we should (if possible) at least consider that first
>
> I don't understand how xmlpath/jsonpath is not able to be implemented with operators.
yeah -- i phrased that badly -- by 'operators' I meant that on both
sides would be json document with absolute minimum fanciness such as
wildcards and predicate matches. basically, 'overlaps' and
(especially) 'contains'.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2012-12-05 19:52:42 | Re: json accessors |
Previous Message | Andrew Dunstan | 2012-12-05 19:51:19 | Re: json accessors |