Boxes - Mailing list pgsql-general

From Pierre-Frédéric Caillaud
Subject Boxes
Date
Msg-id opsebfnhsmcq72hf@musicbox
Whole thread Raw
In response to PG case sensitivity  (Christian Sell <christian.sell@netcologne.de>)
Responses Re: Boxes
List pgsql-general
    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 ...
    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 !

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PG case sensitivity
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Corrupted Data?