"Ardian Xharra \(Boxxo\)" <[EMAIL PROTECTED]> writes:
> Sorry, the exact version is
> PostgreSQL 7.3.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.2
You really, really, really need to update that, ASAP. Even if you
don't need usable expression indexes, compelling reasons can be found a
Wednesday, April 05, 2006 3:14 PM
Subject: Re: [GENERAL] Creating an index on PostgreSQL 7.4.3
> "Ardian Xharra \(Boxxo\)" <[EMAIL PROTECTED]> writes:
> > No, it doesn't work always the same message:
> > ERROR: parser: parse error at or near "(" a
"Ardian Xharra \(Boxxo\)" <[EMAIL PROTECTED]> writes:
> No, it doesn't work always the same message:
> ERROR: parser: parse error at or near "(" at character 47
In that case you're not really talking to a 7.4 server, but something
older --- either syntax works OK for me on 7.4.
regression=# crea
: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
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 c
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
