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

From Donald Fraser
Subject Re: Extracting single coordinate from a box
Date
Msg-id 00fb01c36d87$83880d50$1664a8c0@DEMOLITION
Whole thread Raw
In response to Extracting single coordinate from a box  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extracting single coordinate from a box
Next
From: Jean-Luc Lachance
Date:
Subject: Re: Extracting single coordinate from a box