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

From Jean-Luc Lachance
Subject Re: Extracting single coordinate from a box
Date
Msg-id 3F4E4289.9310085E@nsd.ca
Whole thread Raw
In response to Extracting single coordinate from a box  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
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" <demolish@cwgsy.net> 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 operations need
> > to work on fundamentally different datatypes --- if you write f1[1][0]
> > you are asking to subscript a 2-D array which this isn't.
> >
> > [ experiments further ... ]  Drat, seems that syntax works in 7.4 but
> > not 7.3.  Dunno if that will help you.
>
> I'm using 7.3.4 at the moment and I tried the scenario of using parentheses,
> which didn't work.
> I wrote a function in the end to extract it, but it would have been more
> elegant without it :-(
>
> Thanks again
> Donald
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-admin by date:

Previous
From: "Donald Fraser"
Date:
Subject: Re: Extracting single coordinate from a box
Next
From: Josh Goldberg
Date:
Subject: Re: plpgsql: Bush becomes a null, can not execute null query