From: | Dan Langille <dan(at)langille(dot)org> |
---|---|
To: | Jordan Reiter <jordan(at)breezing(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Case Sensitive "WHERE" Clauses? |
Date: | 2002-09-26 21:08:18 |
Message-ID: | 20020926165736.J30730-100000@m20.unixathome.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Atkins | 2002-09-26 22:01:12 | Passing array to PL/SQL and looping |
Previous Message | Dan Langille | 2002-09-26 20:57:26 | Re: Case Sensitive "WHERE" Clauses? |