Received: from eba-haus.de ([149.228.241.243]) by hub.org (8.10.1/8.10.1) with SMTP id e637uBS69981 for ; Mon, 3 Jul 2000 03:56:11 -0400 (EDT) Received: from kopo001 by eba-haus.de;Mon, 03 Jul 2000 07:43:23 GMT with Novell_GroupWise; Mon, 03 Jul 2000 09:43:23 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Mon, 03 Jul 2000 09:42:54 +0200 From: "Gerhard Dieringer" To: Cc: " Subject: Antw: plpgsql function gets wierd with Null parameters Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e637uCS69985 X-Archive-Number: 200007/13 Skeets Norquist wrote: > When I call the following plpgsql function with the last two parameters > as Null, the first parameter loses it's value: > ma=> select createFund('fred', null, null); > ... > However it works fine when I give values to the last two params: > ma=> select createFund('fred', 'joe', 5); > ... It's a known bug of plpgsql that if one arg is NULL, all other args are also assumed to be NULL. I think (hope) this will be fixed in a future version. Gerhard