Postgres Pro
Downloads
Home   >   mailing lists

Reverse Index ... how to ... - Mailing list pgsql-sql

From Marc G. Fournier
Subject Reverse Index ... how to ...
Date
Msg-id 20060405151239.F947@ganymede.hub.org
Whole thread Raw
Responses Re: Reverse Index ... how to ...  (Oleg Bartunov <oleg@sai.msu.su>)
Re: Reverse Index ... how to ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
I'm still searching through Google and whatnot, but not finding anything 
off the bat ... is there some way of creating a 'REVERSE INDEX' on a 
column in a table?

For instance, when I do a 'CLUSTER' to sort a table based on an INDEX, I'd 
like to sort it in reverse order, so would need the INDEX to go from 
'GREATEST to LOWEST', vs 'LOWEST to GREATEST' ...

Thx

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-sql by date:

Previous
From: "William Leite Araújo"
Date:
Subject: Re: IF statement in Select
Next
From: Oleg Bartunov
Date:
Subject: Re: Reverse Index ... how to ...