"IN" in a geometric database using data type "point"

From: Romain Billoir <billoirr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "IN" in a geometric database using data type "point"
Date: 2010-09-26 08:57:39
Message-ID: AANLkTikrKMe88SrAVPxPMKQtPgAYjNAaKuBTX+=6_MqW@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gurjeet Singh 2010-09-26 10:24:13 Re: 9.0RC1 error variable not found in subplantarget lists
Previous Message Andrus 2010-09-26 08:35:00 Re: 9.0RC1 error variable not found in subplantarget lists