[ moved to General] Greg Mitchell wrote: > 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). We have a TODO for this: * Allow the creation of indexes with mixed ascending/descending specifiers This is possible now by creating an operator class with reversed sort operators. One complexity is that NULLs would then appear at the start of the result set, and this might affect certain sort types, like merge join. -- Bruce Momjian bruce@xxxxxxxxxx EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
