Databases such as Oracle, and DB2 are either equal or better in certain respects. Furthermore, I personally find PostgreSQL to be on par if not better than MSSQL. Aside from PostgreSQL's inability to return multiple recordsets, IMHO it's easier to write stored procedures, functions, views, and triggers in PostgreSQL. In addition PostgreSQL is significantly more consistent syntacticly. Every so often my brother who works for an MS shop will ask me how to do something relatively complex in MSSQL, I'll show him how, but in addition I'll also show him how much easier it would've been in PostgreSQL.

One can argue that when working with SQL Server Studio you don't have to worry about how to do things since the IDE will create most of what you need. However, the same can be said of decent IDEs for PostgreSQL, such as EMS.

Personally, I like the ability to read my functions, views, and triggers, and be able to easily understand what's happening; which is not something I usually experience when working with MSSQL.