"Sven R. Kunze" <srkunze@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
