Subject: yes another NULL question

From: Lawrence Compton <[email-masked]>
Date: Mon, 7 Feb 1994 15:28:31 -0500

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