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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
