how to use geometric shapes?

From: "Henriksen, Jonas F" <jonas(dot)f(dot)henriksen(at)imr(dot)no>
To: <pgsql-general(at)postgresql(dot)org>
Subject: how to use geometric shapes?
Date: 2004-09-12 22:23:06
Message-ID: 1612616523F26F48AB55BC8F5D47917C03CBD1EF@post2.imr.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julian North 2004-09-13 08:46:52 Re: Best practices for migrating a development database
Previous Message Devrim GUNDUZ 2004-09-12 20:26:07 Re: Clustering postgresql