Jordan Reiter wrote: > 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
It's case-sensitive. You can do this: SELECT * FROM People WHERE lower(first_name) = 'jordon' Kevin ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
