Re: Extracting single coordinate from a box
От | Jean-Luc Lachance |
---|---|
Тема | Re: Extracting single coordinate from a box |
Дата | |
Msg-id | 3F4E4289.9310085E@nsd.ca обсуждение исходный текст |
Ответ на | Extracting single coordinate from a box ("Donald Fraser" <demolish@cwgsy.net>) |
Список | 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 по дате отправления: