> 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.
You don't need to use ILIKE if you use: ... lower(attr) LIKE "abc" This
works in Oracle and PG.
David