knowledge-database (beta)

Current group: pgsql.novice

How to create Geo Types from numeric?

How to create Geo Types from numeric?  
Klaus
 Re: How to create Geo Types from numeric?  
Klaus W.
From:Klaus
Subject:How to create Geo Types from numeric?
Date:Fri, 21 Jan 2005 18:43:01 +0100
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
From:Klaus W.
Subject:Re: How to create Geo Types from numeric?
Date:Sat, 22 Jan 2005 02:51:58 +0100
Am Fri, 21 Jan 2005 18:43:01 +0100 schrieb Klaus:

> But where is the desired point() function?

*argh* Maybe i should have simply tried it out :-).
Even althought i could not find it in the docs at first glance....
It works :-)



   

Copyright © 2006 knowledge-database   -   All rights reserved