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

Just ran into another one.  PostgreSQL creates tables as all lowercase,
even if the SQL statement is in uppercase.  Since I'm using the
pg_tables view to check for the existance of tables, this makes the case
in the WHERE clause significant.  Oracle forces everything to uppercase.
PostgreSQL forces everything to lowercase.  Argh!!

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hale Pringle
Sent: Thursday, November 14, 2002 4:31 PM
To: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] 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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)