Re: [firebird-support] Perl, Firebird, and empty Where clause

2012-07-20 Thread Nick Upson
On 19 July 2012 23:23, Paul Vinkenoog wrote: > ** > > > Hello Daniel, > > > > > 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

Re: [firebird-support] Perl, Firebird, and empty Where clause

2012-07-19 Thread Paul Vinkenoog
Hello Daniel, > 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 w

Re: [firebird-support] Perl, Firebird, and empty Where clause

2012-07-19 Thread Andrea Raimondi
On Thu, Jul 19, 2012 at 2:03 PM, Josef Kokeš wrote: > I suppose that you could change the field to NOT NULL DEFAULT ''. Then > would a comparison with empty string work. I don't think that will work. The problem isn't how Firebird handles it, it's how the likes of MySQL and SQLite handle it whic

Re: [firebird-support] Perl, Firebird, and empty Where clause

2012-07-19 Thread 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 - doi

[firebird-support] Perl, Firebird, and empty Where clause

2012-07-19 Thread 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 suc