Thanks for the quick reply. Should I bother requesting this as a
feature in a later release?

________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Dmitry Yemanov
Sent: Tuesday, February 27, 2007 2:25 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Descending primary key in FB 2.0



Rick Debay wrote:

> ALTER TABLE SXC_CLAIM ADD CONSTRAINT PK_SXC_CLAIM PRIMARY KEY
> (RXCLAIMNBR, CLMSEQNBR DESC, CLAIMSTS);

The index key can be either ascending or descending *entirely* (not ASC
for some key segments and DESC for another ones).

> I had thought FB 2.0 added support
> for descending primary keys

It was in v1.5, IIRC.

ALTER TABLE <table name>
ADD CONSTRAINT <constraint name>
PRIMARY KEY (<columns>)
USING DESCENDING INDEX <index name>;

Dmitry

Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.