point-in-polygon error

Поиск
Список
Период
Сортировка
От Don Isgitt
Тема point-in-polygon error
Дата
Msg-id 3D0F9222.85C2091E@soundenergy.com
обсуждение исходный текст
Ответы Re: point-in-polygon error  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: point-in-polygon error  (John Gray <jgray@azuli.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: PostgreSQL.org : A new website design offer
Следующее
От: Laurette Cisneros
Дата:
Сообщение: db monitoring/loggin software?