I think you are forgetting that a box is an array of one dimension with
two points.
So, the first point is B[0] and the second is B[1].
Donald Fraser wrote:
>
> Thanks for the quick response.
>
> - Original Message -
> > "Donald Fraser" <[EMAIL PROTECTED]> writes:
> > > But when I try s
Thanks for the quick response.
- Original Message -
> "Donald Fraser" <[EMAIL PROTECTED]> writes:
> > But when I try something like b[0][0] the passer ignores the second array
> > subscript parameter and returns only a "point".
> You need the extra parentheses because the two subscript o
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> But when I try something like b[0][0] the passer ignores the second array
> subscript parameter and returns only a "point".
Try this:
regression=# select f1, (f1[1])[0] from box_tbl;
f1 | f1
-+-
(2,2),(0,0)
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
ty
