Received: from nts1.rtp.epa.gov (nts1.rtp.epa.gov [134.67.208.208]) by hub.org (8.10.1/8.10.1) with ESMTP id e7LHQlT37143 for ; Mon, 21 Aug 2000 13:26:48 -0400 (EDT) Received: from epamail.epa.gov (IDENT:mvs@wolfpack.rtpnc.epa.gov [134.67.139.59]) by nts1.rtp.epa.gov (8.9.3/8.9.3) with ESMTP id NAA23403 for ; Mon, 21 Aug 2000 13:30:38 -0400 (EDT) Message-ID: <39A1664F.4AFCEF42@epamail.epa.gov> Date: Mon, 21 Aug 2000 13:26:39 -0400 From: Mark Volpe X-Mailer: Mozilla 4.74 [en] (X11; U; Linux 2.2.14-15mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: NULL function arguments? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/206 It seems that why I provide a NULL argument to a PL/pgSQL function it makes the rest of the arguments NULL, too! Consider this function: CREATE FUNCTION callme(text, text) RETURNS boolean AS ' BEGIN RAISE NOTICE ''$1: %'', $1; RAISE NOTICE ''$2: %'', $2; RETURN TRUE; END; ' LANGUAGE 'plpgsql'; So that when I try SELECT callme('hello', 'world'); I get back: NOTICE: $1: hello NOTICE: $2: world But when I do SELECT callme('hello', NULL); I get back: NOTICE: $1: NOTICE: $2: I'm using Postgres 7.0. Possible bug? Mark