Re: advanced index (descending and table-presorted descending) - Mailing list pgsql-hackers

From Greg Mitchell
Subject Re: advanced index (descending and table-presorted descending)
Date
Msg-id 4563654B.5090508@atdesk.com
Whole thread Raw
In response to advanced index (descending and table-presorted descending)  (netsql <cekvenich@gmail.com>)
List pgsql-hackers
First off, not sure this is the right list for this question (maybe 
GENERAL, but HACKERS is for server coding)....

> Can pgSQL 8.x do descending indexes like mySQL 5.1?
> (so 1st column is descending and rest are asscending?)

Not sure why you want this... But you could create an operator class 
with the operators backward I believe (i.e. make less-than use 
greater-than).

> Can pgSQL 8.x do "physically" sorted table (like a forced index order) 
> so we don't need order by?

See man cluster(7).

Greg


pgsql-hackers by date:

Previous
From: netsql
Date:
Subject: advanced index (descending and table-presorted descending)
Next
From: Benny Amorsen
Date:
Subject: Re: quick review