Re: Case Sensitive "WHERE" Clauses?

On Thursday 26 September 2002 19:54, Jordan Reiter wrote:
> Are string comparisons in postgresql case sensitive?

Yes, unless you specify otherwise.

Are you sure you are using the right database? I can
reproduce similar results, but only like this:

mysql>  create temporary table foo (ch char(2), vc varchar(2));
Query OK, 0 rows affected (0.12 sec)

mysql> insert into foo values ('aa','AA');
Query OK, 1 row affected (0.02 sec)

mysql> select * from foo where ch = 'aa';
+------+------+
| ch   | vc   |
+------+------+
| aa   | AA   |
+------+------+
1 row in set (0.01 sec)

mysql> select * from foo where ch = 'AA';
+------+------+
| ch   | vc   |
+------+------+
| aa   | AA   |
+------+------+
1 row in set (0.00 sec)

mysql> select * from foo where vc = 'aa';
+------+------+
| ch   | vc   |
+------+------+
| aa   | AA   |
+------+------+
1 row in set (0.00 sec)


Regards

Ian Barwick
barwick@gmx.net