Home > mailing lists

Re: create a box from point? - Mailing list pgsql-novice

From	Krzysztof Hoffmann
Subject	Re: create a box from point?
Date	August 23, 2010 11:54:03
Msg-id	AANLkTinWT8=gvrbdgC7ziGN_J4xYeXgEj_Q2paNYq3ib@mail.gmail.com Whole thread Raw
In response to	create a box from point? (Frank Bax <fbax@sympatico.ca>)
List	pgsql-novice

Tree view

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

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 by date:

From: Florian Henge
Date: 23 August 2010, 11:49:45
Subject: xml output

From: Thom Brown
Date: 23 August 2010, 12:09:58
Subject: Re: xml output

Re: create a box from point? - Mailing list pgsql-novice

Previous

Next