Re: how to use geometric shapes?
От
Tom Lane
Тема
Re: how to use geometric shapes?
Дата
Msg-id
2454.1095138214@sss.pgh.pa.us
Ответ на
how to use geometric shapes? (Henriksen, Jonas F)
Список
Дерево обсуждения
how to use geometric shapes? "Henriksen, Jonas F" <jonas.f.henriksen@imr.no>
Re: how to use geometric shapes? Tom Lane <tgl@sss.pgh.pa.us>
"Henriksen, Jonas F" writes: > select lat, lon from toperation > where point'(lat,lon)' @ polygon'((50, 0),(70,10),(80,50),(50,80),(50,0))' I think you're confusing the syntax for point literal constants with the constructor function that makes a point value from two float8 values. You probably want something more like select lat, lon from toperation where point(lat,lon) @ polygon '((50, 0),(70,10),(80,50),(50,80),(50,0))' regards, tom lane
В списке pgsql-general по дате отправления