Re: [GENERAL] PL/pgSQL NOT NULL variables

[Tom Lane]

Richard Poole <[EMAIL PROTECTED]> writes:
> I can't get NOT NULL variables to work at all in PL/pgSQL.

Doesn't look like they've ever worked :-(.  If you need a patch for
7.0.*, line 1907 of src/pl/plpgsql/src/pl_exec.c should read

            if (*isNull && var->notnull)

not

            if (isNull && var->notnull)


                        regards, tom lane