On Wed, 2006-03-29 at 03:14 -0800, sylsau wrote: > I use PostgreSQL 8.1 and I would like create and index on a table's > field with a sort condition on this field. > For example, I have a table named books and I want create an index on > the fields title and id_book with an order by id_book descendant. > > I know how to create the index without this condition : > > create index book_index on books(id_book, title); >
The index is already sorted and can be scanned forwards or backwards. Perhaps you want CLUSTER? Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
