From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Klaus <DELTHISvortex25(at)gmx(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to create Geo Types from numeric? |
Date: | 2005-01-25 17:46:53 |
Message-ID: | 20050125174653.GA37157@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, Jan 21, 2005 at 06:43:01PM +0100, Klaus wrote:
> 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?
\df point
List of functions
Result data type | Schema | Name | Argument data types
------------------+------------+-------+------------------------------------
...
point | pg_catalog | point | double precision, double precision
...
SELECT point(10, 20);
point
---------
(10,20)
(1 row)
How are you trying to use point(), what are you expecting to happen,
and what actually does happen?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2005-01-25 17:48:28 | Re: [despammed] Installing dblink |
Previous Message | M. Bastin | 2005-01-25 17:45:31 | Re: programming language for postgresql |