Re: create a box from point?
| От | Krzysztof Hoffmann |
|---|---|
| Тема | Re: create a box from point? |
| Дата | |
| Msg-id | AANLkTinWT8=gvrbdgC7ziGN_J4xYeXgEj_Q2paNYq3ib@mail.gmail.com обсуждение исходный текст |
| Ответ на | create a box from point? (Frank Bax <fbax@sympatico.ca>) |
| Список | pgsql-novice |
This should works:
SELECT box( point(p[0]-.5,p[1]-.5) , point(p[0]+.5,p[1]+.5)) AS boxx from geo;
Krzysztof Hoffmann
SELECT box( point(p[0]-.5,p[1]-.5) , point(p[0]+.5,p[1]+.5)) AS boxx from geo;
Krzysztof Hoffmann
2010/8/23 Frank Bax <fbax@sympatico.ca>
PGSQL 8.4.1 How can I create a box from point?
create table geo (id int, p point);
insert into geo values(1,'(143.032,-81.2315)');
SELECT ((p[0]-.5,p[1]-.5),(p[0]+.5,p[1]+.5)) AS boxx from geo;
boxx
-------------------------------------------
("(142.532,-81.7315)","(143.532,-80.7315)")
SELECT ((p[0]-.5,p[1]-.5),(p[0]+.5,p[1]+.5))::box AS boxx from geo;
ERROR: cannot cast type record to box
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: