Subject Re: [firebird-support] Re: SQL Server Migration to Firebird
Author Milan Babuskov
sqlsvr wrote:
> Thanks! One last question, in standard SQL...there is Row Constructors. Example: SELECT * FROM (('a','1'),('a','2'),('a','3')) AS tbl;
> How come this does not work in Firebird?

Firebird does not support such syntax. You can do:

select * from
select 'a' as col1, 1 as col2 from rdb$database union all
select 'a', 2 from rdb$database union all
select 'a', 3 from rdb$database
) tbl

Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: