Re: [GENERAL] Ascending / Descending Indexes

2009-07-14 Thread Alvaro Herrera
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

[GENERAL] Ascending / Descending Indexes

2009-07-14 Thread Michael Gould
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.   Best Regards -- Michael Gould, Managing Partner I