I just ran into a case where I needed a FULL OUTER JOIN and MySQL let me down. It looks like PostgreSQL would have saved me from UNIONing two queries.