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?

--
Daniel