Received: from olympus.scw.org (209-9-156-98.sdsl.cais.net [209.9.156.98]) by hub.org (8.10.1/8.10.1) with ESMTP id e8GMfws65881; Sat, 16 Sep 2000 18:41:58 -0400 (EDT) Received: from orpheus (orpheus.scw.org [209.9.156.104]) by olympus.scw.org (8.10.1/8.10.1) with ESMTP id e8GMlan28506; Sat, 16 Sep 2000 18:47:36 -0400 Message-Id: <200009162247.e8GMlan28506@olympus.scw.org> From: "Joel Burton" Organization: Support Center of Washington To: pgsql-general@postgreSQL.org, pgsql-sql@postgreSQL.org Date: Sat, 16 Sep 2000 18:47:35 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: All function parameters become NULL if one is? X-mailer: Pegasus Mail for Win32 (v3.12a) X-Archive-Number: 200009/425 I have a function that takes two text parameters. If both of these are non-null, everything works fine. However, if one of these two parameters is null and one is not, the function receives both as null. CREATE FUNCTION F(TEXT,TEXT) RETURNS TEXT AS ' BEGIN RETURN $2; END; ' LANGUAGE 'plpgsql'; SELECT F(null,'Hello'); returns null. Is this intentional? Is there a way around this? -- Joel Burton, Director of Information Systems -*- jburton@scw.org Support Center of Washington (www.scw.org)