point-polygon usage

From: Don Isgitt <djisgitt(at)soundenergy(dot)com>
To: postgresql-general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: point-polygon usage
Date: 2002-06-17 21:44:07
Message-ID: 3D0E5826.C44A96C8@soundenergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2002-06-17 21:54:48 Re: read this and puke
Previous Message Vince Vielhaber 2002-06-17 21:25:42 website design