advanced index (descending and table-presorted descending)

From: netsql <cekvenich(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: advanced index (descending and table-presorted descending)
Date: 2006-11-21 20:03:40
Message-ID: 4b1b8c090611211203l6a10e019x310dc592d43fd661@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

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

tia,
.V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-11-21 20:23:56 Re: pg_dump
Previous Message Vic Cekvenich 2006-11-21 19:54:55 advanced index (descending and table-presorted descending)

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Mitchell 2006-11-21 20:44:59 Re: advanced index (descending and table-presorted descending)
Previous Message Joshua D. Drake 2006-11-21 19:21:32 Re: Open source databases '60 per cent cheaper'