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)