Re:Reasons to choose PostgreSQL 9.6
by Buttons840 on Monday October 03, 2016 @12:50AM
(#12625568)
One specific thing I like to bash about MySQL is that it doesn't support CTEs (aka: with-statements) which are part of the 1999 SQL standard (nearly 20 years old now). I miss them frequently when working with MySQL.
[ Parent
| on HN ]
Postgres has had CTE for a while, but not that long. MySQL 8.0 (the next version) plans to them http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-t...