July 29th, 2003, 07:24 AM
Ascending and Descending Indexes
According to every other SQL on the planet, you create a descending index with:
But in Firebird, according to any docs i can find, you instead create one with:
create index foo_bar_desc on foo ( bar desc )
...which is, in itself, hunky-dory. However, what if you wish to mix ascending and descending fields in one index? What would the Firebird version of this be? Is it even possible?
create desc index foo_bar_desc on foo ( bar )
create index foo_ab on foo ( a asc, b desc )