Re: ERROR: $1 is declared CONSTANT in plpgsql - Mailing list pgsql-novice

Hans Plum <plum@giub.uni-bonn.de> writes:
>         DECLARE
>         InpAscii ALIAS FOR $1;
>         BEGIN
>         InpAscii := $1;

> NOTICE:  plpgsql: ERROR during compile of f_ascii2html near line 7
> ERROR:  $1 is declared CONSTANT

You can't assign to a function's input parameters.  That first
assignment is useless as well as incorrect (if it were allowed,
it'd effectively be $1 := $1, because of your ALIAS).

            regards, tom lane