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