And since MySQL already has got the upperhand in terms of marketing, Oracle
would buy MySQL to make it as the low-end alternative. Never mind the
lack/immature features in MySQL such as stored proc or trigger.
Mysql 5 has stored procedures and triggers.
The fact that you have to change between different "storage engines" to
use transactions properly etc is a little weird (and some of the new
engines are just bizarre), but that's beside the point.
90% of open-source software is written to use only mysql (and it's not
easy to switch to another db) - search freshmeat or sourceforge for
anything postgresql related.. not much there.
Then, even if you do write something to use postgresql a lot of hosts
don't support it anyway ('mysql is good enough').. so you're stuck.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match