Extracting single coordinate from a box - Mailing list pgsql-admin

From Donald Fraser
Subject Extracting single coordinate from a box
Date
Msg-id 00f001c36d83$11ee0220$1664a8c0@DEMOLITION
Whole thread Raw
Responses Re: Extracting single coordinate from a box  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.


pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Logging VACUUM activity in version 7.3
Next
From: Tom Lane
Date:
Subject: Re: Extracting single coordinate from a box