* Tom Lane (t...@sss.pgh.pa.us) wrote: > Stephen Frost <sfr...@snowman.net> writes: > > * Andrew Dunstan (and...@dunslane.net) wrote: > >> I think I'd rather just say "for many data types" or something along > >> those lines, rather than imply that there is some obvious rule that > >> users should be able to intuit. > > > Perhaps with a link to where the informaiton about which exist is > > available..? Or a query to get the list? > > Queries for this sort of thing are covered in the chapter about index > opclasses. The basic query would be like
Right, a link to there from this would be useful, imv.
> select opcintype::regtype from pg_opclass where opcmethod = 403 and
> opcdefault;
>
> but I'm not sure if this is completely useful; it's not obvious for
> example that the "text" opclass is also used for varchar. Another
> point is that some of the operators aren't named in the conventional
> way.
Good point. Hopefully a link over to the index-opclasses.html would be
helpful to users exploring these questions.
Thanks,
Stephen
signature.asc
Description: Digital signature
