Yes, it's work :)

I miss the "computed by" keyword

Thank you.

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: "Firebird-support" <firebird-support@yahoogroups.com>
Sent: Monday, February 26, 2007 2:24 PM
Subject: Re: [firebird-support] Index Expression


> The release notes for Firebird 2.0 have this example:
>
> CREATE INDEX IDX2 ON T2
> COMPUTED BY ( EXTRACT(YEAR FROM COL2) || EXTRACT(MONTH FROM COL2) )
>
> Hence, I'd expect the query you're looking for to be:
>
> CREATE UNIQUE INDEX IDX2 ON T2
> COMPUTED BY ( EXTRACT(MONTH FROM COL2) || EXTRACT(YEAR FROM COL2) )
>
> Did you try exactly like this? Maybe you forgot the outer parenthesis?