Rick Debay wrote:

> A simple example is
>
> SELECT
> (CAST (d.RDB$RELATION_ID) AS DOUBLE)
> FROM
> RDB$DATABASE d

The following works just fine:

select cast(d.rdb$relation_id as double precision)
from rdb$database d

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org