2010/12/17 Hoang-Vu PHUNG <hvu_phung@...>

> As i'm told that firebird is a robust relational database, i could ask you guys about the the SQL conformance.
>
> Basically, i want to migrate from an oracle database to a firebird. I'm using some construct like "WITH" clause and sometime i need analytical functions like partition, rank etc...
>

Oracle is not the best for SQL conformance ;)

about CTE ("WITH" clause), Firebird have it
http://firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-select-cte

about windows functions (partition , rank) it is for 3.0
http://tracker.firebirdsql.org/browse/CORE-1688