how to use geometric shapes? - Mailing list pgsql-general

From Henriksen, Jonas F
Subject how to use geometric shapes?
Date
Msg-id 1612616523F26F48AB55BC8F5D47917C03CBD1EF@post2.imr.no
Whole thread Raw
Responses Re: how to use geometric shapes?
List pgsql-general
Hi,
I cant seem to figure out how to use the geometric shapes in postgres: my query goes like this:

select lat, lon from toperation
where point'(lat,lon)' @ polygon'((50, 0),(70,10),(80,50),(50,80),(50,0))'

This should fetch all values of lat and lon contained by the polygon, but I dont see how I can fetch the lat and lon
values,I just get errors whatever I do. Can anyone help me on this? Thanx,  

regards Jonas:))

--
Jonas F Henriksen
Institute of Marine Research
Norway


pgsql-general by date:

Previous
From: nboutelier@hotmail.com (Nick)
Date:
Subject: Re: Auto increment/sequence on multiple columns?
Next
From: fabien@cyriacrea.net
Date:
Subject: Index inheritance