Michael Gould wrote: > In some SQL engines the engine doesn't need to define both Ascending and > Descending indexes on the same column. Does Postgres need to have indexes > defined for both Ascending and Descending sorts? We use quite a few of > these types of sorts.
A single btree index can be used for both cases. (Unless you want some columns ascending and other columns descending, in which case you need to work extra.) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
