[postgis-users] Problem with pgsql function

[Michael Fuhr]

On Fri, Sep 22, 2006 at 12:42:48PM +1200, palmerj at xtra.co.nz wrote:
> I have had problems with creating a pgsql function:
[...]
>         x    := x(shape);
>         y    := y(shape);
>         z    := z(shape);
>         srid := srid(shape);

Using variables with the same names as other identifiers such as
function, table, or column names results in ambiguities that cause
problems for PL/pgSQL.  This "gotcha" comes up occasionally on the
PostgreSQL mailing lists; the recommended solution is usually to
pick different variable names.

-- 
Michael Fuhr