| 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: | Whole Thread | Raw Message | 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
| 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 |