Re: Oracle For Fun

Hello Jeff,

"Jeff" <jeff_at_work.com> wrote in message
news:bvo85m$mu8$1_at_cronkite.cc.uga.edu...
> In article <YBCTb.205971$I06.2284013_at_attbi_s01>, "VC"
<boston103_at_hotmail.com> wrote:
>
> >
> >
> >Care to elaborate on "doesn' handle null values ? Just being curious...
>
> I mean that it does nothing to handle NULL values passed to it. I mean
that
> it does not return TRUE or FALSE when a NULL value is passed--it returns
NULL.
> Why does this matter? Because NOT NULL <> FALSE. I guess a design
decision
> might be involved where you'd want it to return NULL for NULL values
passed,
> but that wasn't specified... and looking at your test program, it wasn't
for
> you either.
>
>
> > 5 if f1(l.x) then l_str := 'valid'; else l_str := 'not valid'; end
if;
>
> Changing this line to:
>
> if NOT f1(l.x) then l_str := 'not valid'; else l_str := 'valid'; end if;

Is not the trick you've just played called 'creating a strawman' in logic 101 ? My if-statement handles NULLs just fine, thank you.

> .. and you'll get different results when you shouldn't.

No, I won't as the test code snippet clearly shows.

VC Received on Tue Feb 03 2004 - 08:58:27 CST