| From: | Jordan Reiter <jordan(at)breezing(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Case Sensitive "WHERE" Clauses? |
| Date: | 2002-09-26 17:54:41 |
| Message-ID: | a05100312b9b8f9c321b3@[63.172.201.5] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Are string comparisons in postgresql case sensitive?
I keep on having this response:
SELECT *
FROM People
WHERE first_name='jordan'
Result: 0 records
SELECT *
FROM People
WHERE first_name='Jordan'
Result: 1 record
I though that string matching in SQL was case-insensitive. Isn't this correct? If not, what workarounds have been used successfully before? Obviously, formatting the search string for the query is not a solution...
--
Jordan Reiter mailto:jordan(at)breezing(dot)com
Breezing.com http://breezing.com
1106 West Main St phone:434.295.2050
Charlottesville, VA 22903 fax:603.843.6931
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jonesbl | 2002-09-26 18:07:02 | query problem "server sent binary data ... without prior row desc ription ..." |
| Previous Message | Jordan Reiter | 2002-09-26 17:51:33 | None |