Hi,

At April 1, 2004, 16:03, Martijn Tonies wrote:

>> 2. Something else that I haven't proven is that it actually can have
>> indexes that have are mixed order.
>> E.G. PK ASC, Date DESC.:
>> Firebird syntax:
>> CREATE UNIQUE DESCENDING INDEX IDH_DATE_INSP_DESC ON INSPDHST (PART_NO,
>> INSP_DATE, INSP_TIME);
>> Standard syntax:
>> CREATE UNIQUE INDEX IDH_DATE_INSP_DESC ON admin.INSPDHST ( PART_NO,
>> INSP_DATE DESC, INSP_TIME DESC);

> Firebird doesn't have mixed ordered indices.

And, I wasn't able to find a CREATE INDEX syntax in the SQL standard
documents that I have. Even PostgreSQL mentions that there is no
CREATE INDEX in the SQL-92 standard(and it's their own extension to
the SQL language), which confirms my findings for SQL-92 and I can
also confirm the same for SQL-99.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)