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
In response to
pgsql-general by date
|Next:||From: Simon Riggs||Date: 2006-03-29 20:12:16|
|Subject: Re: [SQL] Flight numbers data|
|Previous:||From: Ron Mayer||Date: 2006-03-29 19:45:23|
|Subject: Re: Implementation Suggestions|