From: | Ian Barwick <barwick(at)gmx(dot)net> |
---|---|
To: | Jordan Reiter <jordan(at)breezing(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Case Sensitive "WHERE" Clauses? |
Date: | 2002-09-26 23:00:14 |
Message-ID: | 200209270100.14503.barwick@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-09-26 23:01:53 | Re: FW: query problem "server sent binary data ... without |
Previous Message | jonesbl | 2002-09-26 22:47:44 | FW: query problem "server sent binary data ... without prior row description ..." |