I haven't tried this, but have you tried using a computed column, and
placing the index on that column?

CREATE TABLE tbl_test (
int_id INTEGER NOT NULL,
blnThn date,
mon_year computed by extract(month from "blnThn")||extract(year from
"blnThn"),
primary key(int_id)
);

Create index ind_text_monyear ON tbl_test (mon_year);

Nige.



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Cipto
Sent: Monday, 26 February 2007 3:31 PM
To: Firebird Support
Subject: [firebird-support] Index Expression



Hi,

I want to make an unique index base on the expression:
extract(month from "blnThn")||extract(year from "blnThn")

But it cannot. In what version it will be supported by Firebird?

I use Firebird 2.0 and ODS 11 database

TIA




__________ NOD32 2080 (20070225) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com