Re: Creating an index on PostgreSQL 7.4.3

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)" <axharra@boxxo.info>
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