No, it doesn't work always the same message:
ERROR: parser: parse error at or near "(" at character 47
----- Original Message -----
From: "Martijn van Oosterhout" <kleptog@svana.org>
To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, April 05, 2006 3:01 PM
Subject: Re: [GENERAL] Creating an index on PostgreSQL 7.4.3
On Wed, Apr 05, 2006 at 01:59:46PM -0400, Ardian Xharra (Boxxo) wrote:
> 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
I think expression indexes need another level of parenthesis, so maybe:
CREATE INDEX client__ascname__idx ON client ((TO_ASCII(lower(name),'LATIN
1')));
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
--
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
