Re: [GENERAL] Curiousity about indexing, again

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: Felix Morley Finch <felix(at)crowfix(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Curiousity about indexing, again
Date: 1999-07-05 11:57:42
Message-ID: l03130303b3a64d4d615e@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 07:11 +0300 on 05/07/1999, Felix Morley Finch wrote:

> Adding "where 'now' > stmp" (stmp is type datetime) tricks the optimizer
> appropriately. However, it only does so for "order by stmp". If I
> use "order by stmp DESC", explain says it will have to sort before
> doing the index scan.

Hmm. It strikes me that if "where 'now' > stmp" helped you with an
ascending sort, something like "where '-infinity' < stmp" should help you
with a descending sort. But this is merely a shot in the dark.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tamas Nyitrai 1999-07-05 12:01:11 Re: [GENERAL] GROUP BY problem with 6.5
Previous Message Chris Bitmead 1999-07-05 07:00:46 Re: [GENERAL] oid as a reference