i'm curious why some people who prefer open-source databases prefer mysql over postgres?

i've used both and found that they're equally easy to setup and admin and roughly the same speed (recent versions of postgres have gotten much faster). but then postgres also supports transactions, foreign keys, subselects and all those other things that many of us would consider necessary elements of a real DBMS.

are the various built in functions in mysql that much more of a convenience? or is it just that mysql has gotten so much hype lately that people haven't even tried postgres?

not trying to troll here, i've had nothing but pleasant experiences with mysql. i'm honestly curious what people see as mysql's real advantage over postgres?

I have stuck with MySQL primarily because I'm used to it.
I started with mSQL, which lacks some vital features, so when I found
MySQL I thought it was great. For simple databases, MySQL
is easy to use and learn. Postgres has more advanced features
that compete with the "big boys", but I've never needed them
for the kind of work I do. I considered switching once, in
case of future need, but I didn't like the way Postgresql
handled things like OIDs and stuff as opposed to MySQL. I'm
sure if I had started out with Postgres I'd swear by it instead.

When putting a smiley right before a closing parenthesis, do you:

Use two parentheses: (Like this: :) )
Use one parenthesis: (Like this: :)
Reverse direction of the smiley: (Like this: (: )
Use angle/square brackets instead of parentheses
Use C-style commenting to set the smiley off from the closing parenthesis
Make the smiley a dunce: (:>
I disapprove of emoticons
Other