Re: Pb with arrays in PostgresQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: p(dot)thomas(at)smie(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Pb with arrays in PostgresQL
Date: 2000-10-10 16:12:09
Message-ID: 19406.971194329@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Pascale Thomas <p(dot)thomas(at)smie(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2000-10-10 17:04:56 Re: Referencial integrity when there are timestamp primary keys
Previous Message Pascale Thomas 2000-10-10 13:10:47 Pb with arrays in PostgresQL