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:[EMAIL PROTECTED] Breezing.com http://breezing.com 1106 West Main St phone:434.295.2050 Charlottesville, VA 22903 fax:603.843.6931 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
