Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com
	[216.136.174.114])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1KAoHx91557
	for <pgsql-interfaces@postgresql.org>;
	Tue, 20 Feb 2001 05:50:17 -0500 (EST)
	(envelope-from janwieck@yahoo.com)
Received: from a58c4.pppool.de (HELO jupiter.jw.home) (213.6.88.196)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 20 Feb 2001 10:50:13 -0000
X-Apparently-From: <janwieck@yahoo.com>
Received: (from janwieck@localhost)
	by jupiter.jw.home (8.9.3/8.9.3) id EAA02976;
	Tue, 20 Feb 2001 04:19:52 -0500
From: Jan Wieck <janwieck@Yahoo.com>
Message-Id: <200102200919.EAA02976@jupiter.jw.home>
Subject: Re: passing values to a function
In-Reply-To: 
 <Pine.LNX.4.21.0102200003440.31428-100000@nanu.visionforisrael.com>
	from Cedar Cox at "Feb 20, 2001 00:19:09 am"
To: Cedar Cox <cedarc@visionforisrael.com>
Date: Tue, 20 Feb 2001 04:19:52 -0500 (EST)
CC: Jan Wieck <janwieck@yahoo.com>, pgsql-interfaces@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL68 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200102/128
X-Sequence-Number: 1085

Cedar Cox wrote:
> Giving
>   select update_sentitems('INSERT',1);
> returns
>   NOTICE:   varop = INSERT
> as expected, however if you give
>   select update_sentitems('INSERT',null);
> this is returned:
>   NOTICE:   varop = <NULL>
>
> BTW, it doesn't matter if both parameters are text or int4.  Also, it
> doesn't matter which one is given as null, they both turn up null.
> Bottom line seems to be that if you call the function with any parameter
> null, they are all null.  Sooo.. what's up here?  Is this a bug that's
> been fixed in 7.0.3? (I'm still using 7.0.2).

    I  wouldn't call it a bug, it was a lack of capabilities with
    the pre7.1 function manager. It had only one flag for NULL to
    pass  to  the  function,  so  it said "there is a NULL, but I
    don't tell you which arg it is".

    7.1 is the first that does it correct.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com