Please don't reply to existing threads to start a new thread. This makes the
archives less usable.
On Tue, Sep 14, 2004 at 14:00:43 +0200,
Pierre-Frédéric Caillaud <lists@boutiquenumerique.com> wrote:
>
> I have a table containing coordinates and I want to insert these
> into another table, converting them to boxes.
>
> I would like to use the same syntax as arrays :
>
> INSERT INTO ... (coords) SELECT ARRAY[a,b,c] FROM ...
>
> But I want boxes. Is there a way to do this ?
>
> SELECT BOX[[a,b],[c,d]] FROM ...
You want something like box(point(a,b),point(c,d)) .
> raises a Syntax Error.
> And I'd like to avoid to concatenate strings to build a box
> representation like
> '((1,2),(3,4))'::box;
>
> Is there a way ?
>
> Thanks !
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings