Subject Re: [firebird-support] Perl, Firebird, and empty Where clause
Author Josef KokeŇ°
> 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?

I suppose that you could change the field to NOT NULL DEFAULT ''. Then
would a comparison with empty string work.