Re: Ascending / Descending Indexes

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