Re: JSON Path and GIN Questions - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: JSON Path and GIN Questions
Date
Msg-id 636E83FD-DC39-48F2-8F81-ED133AF5289A@justatheory.com
Whole thread Raw
In response to Re: JSON Path and GIN Questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: JSON Path and GIN Questions
List pgsql-hackers
On Sep 17, 2023, at 12:20, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> After thinking about it for awhile, I think we need some more
> discursive explanation of what's allowed, perhaps along the lines
> of the attached.  (I still can't shake the feeling that this is
> duplicative; but I can't find anything comparable until you get
> into the weeds in Section V.)
>
> I put the new text at the end of section 11.1, but perhaps it
> belongs a little further up in that section; it seems more
> important than some of the preceding paras.

I think this is useful, but also that it’s worth calling out explicitly that functions do not count as indexable
operators.True by definition, of course, but I at least had assumed that since an operator is, in a sense, syntax sugar
fora function call, they are in some sense the same thing. 

A header might be useful, something like “What Counts as an indexable expression”.

Best,

David


Attachment

pgsql-hackers by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Fix output of zero privileges in psql
Next
From: "David E. Wheeler"
Date:
Subject: to_regtype() Raises Error