point-in-polygon error
От | Don Isgitt |
---|---|
Тема | point-in-polygon error |
Дата | |
Msg-id | 3D0F9222.85C2091E@soundenergy.com обсуждение исходный текст |
Ответы |
Re: point-in-polygon error
Re: point-in-polygon error |
Список | 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 по дате отправления: