Re: [DOCS] GIST operators docs [was: [HACKERS] Patch: add GiST support for BOX @> POINT queries] - 08-11-2012 , 12:04 PM
Daniele Varrazzo <daniele.varrazzo (AT) gmail (DOT) com> writes:
what would happen if we tried to annotate every operator supported by
btree indexes that way, for example. It'd be very cluttering. It'd
probably be pretty cluttering even if we restrict it to GIST cases.
I think the charter of 9.11 is to tell you what the operators *do*,
not which ones are amenable to indexing.
Over in 11.9
there are sample queries for finding out which operators are indexable
by consulting the system catalogs directly. I wonder whether it'd be
helpful to provide some simplified version of those queries in 11.2,
instead of or in addition to the text that's there now.
Alternatively, I could see adding tables of supported operators in
the GIST (and SPGIST and GIN) chapters of part VII, and linking to
those from 11.2.
Another idea is to extend psql's \do command to report indexability
of the operators it shows.
regards, tom lane
Sent via pgsql-docs mailing list (pgsql-docs (AT) postgresql (DOT) org)
To make changes to your subscription: