Re: create a box from point?

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(at)sympatico(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>