Subject Re: [firebird-support] Backporting query to Firebird 1.5
Author Anderson Farias
Hi,

> SELECT * FROM TABLE WHERE TIMESTAMPFIELD > (CURRENT_TIMESTAMP - CAST(?
> as DECIMAL(18,9))

I've tested against FB 1.5.4 and it works fine


> However, if I try to execute this in older system with Firebird 1.5,
> I get "Unknown data type" error.

I can't reproduce the error against fb 1.5.4, ex:

select current_timestamp-cast(10.321 as numeric(18,9)) from rdb$database;

runs just fine!


Regards,
Anderson Farias