Array problem

[Panagiotis Papadakos <papadako@xxxxxxxxxx>]

Hi everybody.

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 
KEY(id));

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?

P.S.

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.

	Panagiotis Papadakos