----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <ib-support@yahoogroups.com>
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
or
> > 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