Thread: advanced index (descending and table-presorted descending)

Can pgSQL 8.x do descending indexes like mySQL 5.1? <br />(so 1st column is descending and rest are asscending?) <br
/><br/><br />Can pgSQL 8.x do "physically" sorted table (like a forced index order) so we don't need order by? <br
/><br/>tia, <br />.V <br /> 

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