On Dec 5, 2012, at 9:57 AM, Merlin Moncure <mmonc...@gmail.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. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
