How to create Geo Types from numeric?

Поиск
Список
Период
Сортировка
От Klaus
Тема How to create Geo Types from numeric?
Дата
Msg-id pan.2005.01.21.17.42.06.882246@gmx.de
обсуждение исходный текст
Ответы Re: How to create Geo Types from numeric?  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Help with concurrent insertions.
Следующее
От: "Mike Disbrow"
Дата:
Сообщение: Installing dblink