Null date

is a date variable comparable to null?

I mean if i have a table temp
with

tempid		number constraint pk_tempid primary key;
tempdate	date;

and I did

insert temp (tempid) values (1);

and then I do

select tempdate into p from temp where tempid = 1;

obviously, tempdate should be a null.

So, can I do

if tempdate = null then

        htp.p('it is null!');
end if;

or should I compare the tempdate to some other stuff so that I can tell it is empty?

Thanks in advance

wei Received on Wed May 12 1999 - 16:22:06 CDT