Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc)

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: Timur <itvthor(at)sdf(dot)lonestar(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc)
Date: 2002-08-24 16:34:44
Message-ID: 20020824123444.71194920.alvherre@atentus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

En Sat, 24 Aug 2002 20:18:25 +0500
Timur <itvthor(at)sdf(dot)lonestar(dot)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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2002-08-24 17:53:22 Re: [GENERAL] PostgreSQL 7.2.2: Security Release
Previous Message Stephan Szabo 2002-08-24 15:56:43 Re: CREATE INDEX .. ON table1 (field1 asc, field2 desc)