According to every other SQL on the planet, you create a descending index with:

Code:
create index foo_bar_desc on foo ( bar desc )
But in Firebird, according to any docs i can find, you instead create one with:

Code:
create desc index foo_bar_desc on foo ( bar )
...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?

Code:
create index foo_ab on foo ( a asc, b desc )