How to create Geo Types from numeric? - Mailing list pgsql-novice

From Klaus
Subject How to create Geo Types from numeric?
Date
Msg-id pan.2005.01.21.17.42.06.882246@gmx.de
Whole thread Raw
Responses Re: How to create Geo Types from numeric?
List pgsql-novice
Hi!

I'm trying to fill a table which has a polygon-type column from another
table with discrete numeric data. It contains circle descriptions by x,y,r
components in seperate columns.

There is a nice polygon() functions which can estimate circles by
polygons. Another one converts a point and radius to a circle
(circle(point, r)). But with which function may i generate a point from
two discrete coordinates? I imaginge something like that:

 =polygon( circle( point( oldx, oldy ), radius )

But where is the desired point() function?

Thank you very much!
Klaus


pgsql-novice by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Help with concurrent insertions.
Next
From: "Mike Disbrow"
Date:
Subject: Installing dblink