Postgres Pro
Downloads
Home   >   mailing lists

Re: Pb with arrays in PostgresQL - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Pb with arrays in PostgresQL
Date
Msg-id 19406.971194329@sss.pgh.pa.us
Whole thread Raw
In response to Pb with arrays in PostgresQL  (Pascale Thomas <p.thomas@smie.com>)
List pgsql-bugs
Tree view 
Pascale Thomas <p.thomas@smie.com> writes:
>     "select  nom_soc from societe where event_ok[1]=1"
> The error message is : Unable to locate type name 'event_ok' in catalog

In 6.5.* this only works if you write out the fully qualified name:
    select  nom_soc from societe where societe.event_ok[1]=1

I'd strongly recommend updating to Postgres 7.0.2, because this is not
the only array-related bug you will find in 6.5 ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Pascale Thomas
Date:
Subject: Pb with arrays in PostgresQL
Next
From: Stephan Szabo
Date:
Subject: Re: Referencial integrity when there are timestamp primary keys