|Subject||Re: indexes are one way streets|
> I still feel that this is some kind of limitation but it's the wayI 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).
> firebird works. would it make sense to post this as feature request
> or do you consider this nonsense?