Daniele Varrazzo <daniele.varrazzo (AT) gmail (DOT) com> writes:
I agree this is pretty incomplete ...

.... but I don't think I want to fix it along those lines. Consider
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
http://www.postgresql.org/docs/devel...s-opclass.html
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:
http://www.postgresql.org/mailpref/pgsql-docs