Thanks for your answer.
 
If i'm not mistaken, SQL conformance was influenced by big actors in RDBMS (DB2 , Oracle). MySQL is very popular but its syntax is strange for me. May be PostgreSQL is better in SQL conformance but i have no experience and i'm told its performance is not the best.
 
Regards,
Vu

--- En date de : Ven 17.12.10, Philippe Makowski <makowski@...> a écrit :


De: Philippe Makowski <makowski@...>
Objet: Re: [firebird-support] Questions regarding SQL conformance
À: firebird-support@yahoogroups.com
Date: Vendredi 17 décembre 2010, 21h33


 



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










[Non-text portions of this message have been removed]