One big difference that you should look for is case sensitivity in WHERE
clauses. I know that SQL-SERVER defaults to case-insensitive and you have
to go through hoops to do a case sensitive search. PostreSQL defaults to
case sensitive and uses the non-standard "ILIKE" verb to generate a
case-insensitive WHERE clause.