Creating an index on PostgreSQL 7.4.3

["Ardian Xharra (Boxxo)" <axharra@xxxxxxxxxx>]

Hello,

I have a client who is still using the version 7.4.3

and creating an index like this doesn't work:

CREATE INDEX client__ascname__idx  ON client (TO_ASCII(lower(name),'LATIN 1'));

Does exists another way of creating an index in varchar who take on consideration also the accents 

 

Thanks!

 

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.5/301 - Release Date: 04/04/2006