Subject Re: [firebird-support] Select * from where 0=1
Author Jerome Bouvattier
Hi Martijn,

> > I need to come up with a statement that's as fast a #2 but also works on
> > most IB/FB engines.
> > How should this statement look like ?

> select * from table where pkcolumn = nonexistingvalue.

The problem with this statement is that it forces me to know a bit too much
about the table :
a column name and a non-existing value.

Ideally, I'd need something more generic.
Any other hint ?

Thanks a lot.

--
Jerome