Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA11510 for postgres-dist; Mon, 7 Feb 1994 12:29:09 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199402072029.MAA11510@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from afterlife.ncsc.mil (afterlife.ncsc.mil [144.51.1.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id MAA11501 for <postgres@nobozo.CS.Berkeley.EDU>; Mon, 7 Feb 1994 12:29:08 -0800
Received: from hades.ncsc.mil (hades [144.51.1.4]) by afterlife.ncsc.mil (8.6.4/8.6.4) with SMTP id PAA28931 for <postgres@postgres.berkeley.edu>; Mon, 7 Feb 1994 15:28:31 -0500
Date: Mon, 7 Feb 1994 15:28:31 -0500
From: Lawrence Compton <lhcompt@afterlife.ncsc.mil>
Message-Id: <199402072028.PAA28931@afterlife.ncsc.mil>
To: postgres@postgres.Berkeley.EDU
Subject: yes another NULL question
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Mon, 07 Feb 94 12:29:09 -0800
Resent-XMts: smtp

I have a question about passing NULL into POSTQUEL functions. Consider
the following...

	create t (x=int4, y=text) \g

	define function app
		(language="postquel", returntype=int4)
		arg is (text)
		as
		"append t (x=NULL, y=$1)
		retrieve (x=1)" \g

	retrieve (x=app(NULL)) \g

The last command yields an error message stating that the function 'app()'
does not allow NULL inputs. Is there a way to force a function to accept
NULL parameters?

							Larry Compton