MS SQL Server's text search is far superior to PostgreSQL's. Otherwise, not a huge difference.

Also, if you're a Microsoft shop, it's easier to deal with than learning Postgres's unixy ways. And you can program sprocs using .Net