From: Jan Wieck <janwieck@Yahoo.com>
To: Cedar Cox <cedarc@visionforisrael.com>
Cc: Jan Wieck <janwieck@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: passing values to a function
Date: Tue, 20 Feb 2001 04:19:52 -0500 (EST)
Message-ID: <200102200919.EAA02976@jupiter.jw.home> (raw)
In-Reply-To: <Pine.LNX.4.21.0102200003440.31428-100000@nanu.visionforisrael.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: janwieck@Yahoo.com, cedarc@visionforisrael.com
Subject: Re: passing values to a function
In-Reply-To: <200102200919.EAA02976@jupiter.jw.home>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox