Paul G. Weiss wrote:
[snip]
but
DB<3> x $dbh->selectall_arrayref('select x,b from tbl where a=? and
b=?', undef, 4, undef)
0 ARRAY(0x9ba0530)
empty array
i.e. the 'b=?' in the statement where I bind the value to undef does
_not_ act like
'b is null'.
No - it doesn't. It acts like 'b=null', as is should. 'b=null' can
never be true.
This is not Oracle specific. It is covered under 'NULL values' in
the DBI pod.
--
Charles Jardine - Computing Service, University of Cambridge
[EMAIL PROTECTED] Tel: +44 1223 334506, Fax: +44 1223 334679
