point-in-polygon error - Mailing list pgsql-general

From Don Isgitt
Subject point-in-polygon error
Date
Msg-id 3D0F9222.85C2091E@soundenergy.com
Whole thread Raw
Responses Re: point-in-polygon error  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: point-in-polygon error  (John Gray <jgray@azuli.co.uk>)
List pgsql-general
No response to my first plea; maybe this time.

Hi.

I am trying to determine if some lat/longs stored in a database are
contained within a defined polygon using the very nice builtin operators

and types of postgresql; to wit,

gds2=> select count(*) from master where point '(latitude,longitude)' @
polygon
'(
(3200000,10200000),(3187500,10262500),(3112500,10230000),(3112500,10187500),(3200000,10200000))';

ERROR:  Bad point external representation '(latitude,longitude)'
ERROR:  Bad point external representation '(latitude,longitude)'

I have tried several variations on this theme to no avail. What am I
doing wrong?

I am using version 6.5.2, latitude and longitude are float.

Thank you for your help.

Don Isgitt




pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: PostgreSQL.org : A new website design offer
Next
From: Laurette Cisneros
Date:
Subject: db monitoring/loggin software?