I've been working with PHP and mySQL for the past couple years, but haven't really had the 'chance' to explore much further. I see several job listings talk about postgreSQL and msSQL and such.

Looking to use an open source general-purpose database? This extensive comparison of MySQL vs. PostgreSQL explores the strengths and weaknesses of each.