Extracting single coordinate from a box

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Extracting single coordinate from a box
Date: 2003-08-28 16:40:15
Message-ID: 00f001c36d83$11ee0220$1664a8c0@DEMOLITION
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm wondering if anyone knows how to extract a single co-ordinate from the data
type "box".

I know that I can access a single co-ordinate from a "point" using the array
notation: p[0] or p[1] where p is of type "point".
I can extract a single "point" from a "box" with b[0] or b[1] where b is of
type "box".
But when I try something like b[0][0] the passer ignores the second array
subscript parameter and returns only a "point".

Many thanks in advance,
Donald Fraser.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-08-28 16:55:06 Re: Extracting single coordinate from a box
Previous Message Murthy Kambhampaty 2003-08-28 16:35:38 Logging VACUUM activity in version 7.3