Re: Reverse Key Index

"Sven R. Kunze" <srkunze@tbz-pariv.de> writes:
> does PostgreSQL support the concept of reverse key indexing as described
> here? I couldn't find any documentation on this yet.

> http://www.toadworld.com/platforms/oracle/w/wiki/11075.reverse-key-index-from-the-concept-to-internals.aspx

There's nothing built-in for that (and frankly, it doesn't sound useful
enough that we'd ever add it).  You could get the effect easily enough
with an expression index on a byte-reversing function.  A related thing
that people often do is create an index on a hash function.

            regards, tom lane