Re: PL/pgSQL NOT NULL variables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Poole <richard(dot)poole(at)vi(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL NOT NULL variables
Date: 2001-01-06 01:46:24
Message-ID: 15847.978745584@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Poole <richard(dot)poole(at)vi(dot)net> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian deSouza 2001-01-06 02:57:03 DROP SEQUENCE ?
Previous Message Alex Pilosov 2001-01-06 01:38:30 Re: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)