At 03:10 PM 6/08/2004 +0200, you wrote:

> > > > You can create DESC primary (and matched order foreign) keys in
>Firebird
> > >1.5.
> > >
> > >Oh yes, I forgot about that one. Quick question (and without trying):
> > >what happens if you mix an ASC FK index with a DESC PK index?
> >
> > Read my statement again....and give yourself a Bamsemum, quick!!
>
>Sorry. still don't get it (don't have any Bamsemums though)...
>
>If you create an FK that points to a DESC PK, will it automatically
>create a DESC FK?

No; it means if you create a USING <indexname> DESC primary key, any
foreign keys pointing to it must also be USING <indexname> DESC (as
explained in the release notes).

Is that better for you than a B*m****M? Or nearly as good?
/h