Re: [GENERAL] Curiousity about indexing, again

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