July 29th, 2003, 07:24 AM
|
|
Registered User
|
|
Join Date: Apr 2003
Posts: 12
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Ascending and Descending Indexes
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 )
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
