Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc) - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc)
Date
Msg-id 20020824123444.71194920.alvherre@atentus.com
Whole thread Raw
In response to CREATE INDEX .. ON table1 (field1 asc, field2 desc)  (Timur <itvthor@sdf.lonestar.org>)
Responses Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
En Sat, 24 Aug 2002 20:18:25 +0500
Timur <itvthor@sdf.lonestar.org> escribió:

Hello,

> I am new to PostgreSQL and databases in general, and I have this
> question: why it is not possible to specify ordering when creating an
> index?

Because there is no point in doing so.  Postgres automatically scans an
index in reverse direction if you want to use descending order.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc)
Next
From: pgsql-gen Newsgroup (@Basebeans.com)
Date:
Subject: Cron /var/news2mail/postgresql_n2m