point-in-polygon error

From: Don Isgitt <djisgitt(at)soundenergy(dot)com>
To: postgresql-general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: point-in-polygon error
Date: 2002-06-18 20:03:47
Message-ID: 3D0F9222.85C2091E@soundenergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurette Cisneros 2002-06-18 20:09:27 db monitoring/loggin software?
Previous Message Devrim GUNDUZ 2002-06-18 19:40:55 PostgreSQL.org : A new website design offer