Re: How to create Geo Types from numeric?

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/

In response to

Browse pgsql-novice by date

  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