Skip site navigation (1) Skip section navigation (2)

Re: Create an index with a sort condition

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: sylsau <sylsau14(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create an index with a sort condition
Date: 2006-03-29 19:57:44
Message-ID: 1143662264.32384.301.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Simon RiggsDate: 2006-03-29 20:12:16
Subject: Re: [SQL] Flight numbers data
Previous:From: Ron MayerDate: 2006-03-29 19:45:23
Subject: Re: Implementation Suggestions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group