"IN" in a geometric database using data type "point" - Mailing list pgsql-general

From Romain Billoir
Subject "IN" in a geometric database using data type "point"
Date
Msg-id AANLkTikrKMe88SrAVPxPMKQtPgAYjNAaKuBTX+=6_MqW@mail.gmail.com
Whole thread Raw
Responses Re: "IN" in a geometric database using data type "point"  (Andrew Hunter <ahunter@ucalgary.ca>)
Re: "IN" in a geometric database using data type "point"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi, i'm trying to request a database using data type "point" using keyword "IN" with a list of point generated by PHP, like this:
'SELECT * FROM map WHERE position IN ((point(-1,-1), (point(1,-1), point(1,1), point(-1,1))'
but this request returns me an error: operator doesn't exist point = point.
so i tried to use a path unstead of list of point like this:
'SELECT * FROM map WHERE position <@ path '(point(-1,-1), (point(1,-1), point(1,1), point(-1,1))'
but this request returns me the point 0,0???

Is anybody have a suggestions?

Thanks.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: 9.0RC1 error variable not found in subplantarget lists
Next
From: Gurjeet Singh
Date:
Subject: Re: 9.0RC1 error variable not found in subplantarget lists