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)