"Sven R. Kunze" <srkunze(at)tbz-pariv(dot)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