From: | "Ardian Xharra \(Boxxo\)" <axharra(at)boxxo(dot)info> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Creating an index on PostgreSQL 7.4.3 |
Date: | 2006-04-05 19:14:54 |
Message-ID: | 02bb01c658e5$38bd6850$6a01a8c0@BOXXO.ARDIAN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry, the exact version is
PostgreSQL 7.3.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.2
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ardian Xharra (Boxxo)" <axharra(at)boxxo(dot)info>
Cc: <pgsql-general(at)postgresql(dot)org>; "Martijn van Oosterhout"
<kleptog(at)svana(dot)org>
Sent: Wednesday, April 05, 2006 3:14 PM
Subject: Re: [GENERAL] Creating an index on PostgreSQL 7.4.3
> "Ardian Xharra \(Boxxo\)" <axharra(at)boxxo(dot)info> 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=# create table client(name text);
> CREATE TABLE
> regression=# CREATE INDEX client__ascname__idx ON client
(TO_ASCII(lower(name),'LATIN 1'));
> CREATE INDEX
> regression=# select version();
> version
> ----------------------------------------------------------------
> PostgreSQL 7.4.12 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
> (1 row)
>
> regards, tom lane
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.3.5/301 - Release Date: 04/04/2006
>
>
--
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:20:44 | Re: Creating an index on PostgreSQL 7.4.3 |
Previous Message | Tom Lane | 2006-04-05 19:14:32 | Re: Creating an index on PostgreSQL 7.4.3 |