[postgis-users] Problem with pgsql function

Michael Fuhr mike at fuhr.org
Thu Sep 21 19:27:56 PDT 2006


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



More information about the postgis-users mailing list