Re: Case Sensitive "WHERE" Clauses?

On Thu, 26 Sep 2002, Jordan Reiter wrote:

> Are string comparisons in postgresql case sensitive?

Yes, AFAIK.

I disagree with your comments and recommendations posted at
http://www.postgresql.org/idocs/index.php?datatype-character.html because
my testing shows that varying text and fixed test comparisons are both case
sensitive.

testing=# \d casetest
Table "casetest"
Column | Type | Modifiers
--------+---------------+-----------
name | text |
city | character(10) |

testing=# select * from casetest;
name | city
------+------------
Dan | Ottawa
(1 row)

testing=# select * from casetest where name = 'Dan';
name
------
Dan
(1 row)

testing=# select * from casetest where name = 'dan';
name
------
(0 rows)

testing=# select * from casetest where city = 'ottawa';
name | city
------+------
(0 rows)