Re: PostgreSQL/Oracle/MSSQL differences (was: streaming result

> 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