From: | "Ardian Xharra \(Boxxo\)" <axharra(at)boxxo(dot)info> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
Subject: | Re: Creating an index on PostgreSQL 7.4.3 |
Date: | 2006-04-05 19:07:43 |
Message-ID: | 02b101c658e4$3795a6a0$6a01a8c0@BOXXO.ARDIAN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)org>
To: "Ardian Xharra (Boxxo)" <axharra(at)boxxo(dot)info>
Cc: <pgsql-general(at)postgresql(dot)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(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-04-05 19:09:14 | Re: full join question... |
Previous Message | Tom Lane | 2006-04-05 19:02:18 | Re: Couldn't create a database in PG 8.1.3 win32 |