Re: Extracting single coordinate from a box

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Extracting single coordinate from a box
Date: 2003-08-28 17:12:03
Message-ID: 00fb01c36d87$83880d50$1664a8c0@DEMOLITION
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks for the quick response.

----- Original Message -----
> "Donald Fraser" <demolish(at)cwgsy(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Josh Goldberg 2003-08-28 17:55:58 Re: plpgsql: Bush becomes a null, can not execute null query
Previous Message Tom Lane 2003-08-28 16:55:06 Re: Extracting single coordinate from a box