Subject Re: [ib-support] RE: indexes are one way streets
Author Woody
----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <>
Sent: Monday, August 12, 2002 5:33 AM
Subject: Re: [ib-support] RE: indexes are one way streets

> Michael,
> > well, this is the problem: this does not work. one can specify ascending
> > descending only at the beginning like in:
> > create descending index myindex on people (first_name, birthday)
> Exactly right.
> Must have beeen working with too many different databases lately. I'm
> sorry.
> Then I'd try with separate indexes (as others have suggested)
> optionally adding a column to improve selectivity (like in first_name,
> my_id).

You were probably thinking of the ORDER BY clause of a query which does
allow each field declared to be either ascending or descending. <g>

Woody (TMW)

"To invent, you need a good imagination and a pile of junk."
Thomas Edison