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

From Michael Fuhr
Subject Re: How to create Geo Types from numeric?
Date
Msg-id 20050125174653.GA37157@winnie.fuhr.org
Whole thread Raw
In response to How to create Geo Types from numeric?  (Klaus <DELTHISvortex25@gmx.de>)
List 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/

pgsql-novice by date:

Previous
From: Inpreet Singh
Date:
Subject: Postgres database access problem
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] Installing dblink