I have created a table containing an array of points
(each point exists only once in the array).
CREATE TABLE lala (id INT NOT NULL, occur point not NULL, PRIMARY
I am trying to find a way to get the position of array elements
that have a specific x coordinate.
How can I do it?
select * from lala where point'(289,0)' ?| any (occur);
returns the whole tuples that have points with x=289 in their array.
Thanks in advance.
pgsql-general by date
|Next:||From: Jacek Rembisz||Date: 2008-06-26 08:40:12|
|Subject: Re: a question about data corruption|
|Previous:||From: Rodrigo Gonzalez||Date: 2008-06-26 06:34:59|
|Subject: Re: ERROR: could not open relation with OID 2836|