Re: how to use geometric shapes?

"Henriksen, Jonas F" <jonas(dot)f(dot)henriksen(at)imr(dot)no> 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