> I still feel that this is some kind of limitation but it's the way
> firebird works. would it make sense to post this as feature request
> or do you consider this nonsense?

I think it makes sense. You are allowed to have indexes spawning several fields - even fields of various types (e.g char and integer), so why shouldn't you be allowed to declare one as ascending and the other as descending? I'm not certain I have data where this would make sense, but I have no problem seeing that this could be useful for others. E.g. if you had a generated field as PK and you wanted to see which of your 100 first customers that had placed an order the last week, the ideal index would be (customer asc, date desc).

Set