Subject Perl, Firebird, and empty Where clause
Author Daniel L. Miller
I'm trying to have an existing perl program, that is using the DBI
system for theoretical database interoperability, to use Firebird. I've
discovered that, as a standard, this program executes statements such as,

select * from table where pkey=''

That apparently works with Mysql - doing such a select with a specified
empty where clause will return the full table. Firebird - probably more
correctly - does a comparison for empty/null and returns...nothing.
Without changing the perl script, is there a way I can have Firebird
actually return the table using the above SQL?