Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group