Create an index with a sort condition

Поиск
Список
Период
Сортировка
От sylsau
Тема Create an index with a sort condition
Дата
Msg-id 1143630853.043754.111900@v46g2000cwv.googlegroups.com
обсуждение исходный текст
Ответы Re: Create an index with a sort condition  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-general
Hello,

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);


But, I don't know to create this index with the sort condition.
Someone has an idea ?

Thanks to help me.

Sylvain.


В списке pgsql-general по дате отправления:

Предыдущее
От: Jo De Haes
Дата:
Сообщение: Re: invalid page header
Следующее
От: "raj"
Дата:
Сообщение: checking data type