Re: [BUGS] Pb with arrays in PostgresQL

[Tom Lane]

Pascale Thomas <[EMAIL PROTECTED]> 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