Subject Re: [firebird-support] Re: SQL Server Migration to Firebird
Author Ann W. Harrison
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?

Probably because that syntax is an extension specific to SQLServer.
Other systems (e.g. PostgreSQL) have similar constructs with slightly
different syntax.



P.S. I don't believe that's your last question - feel free to keep