Quoth "Relaxin" <[EMAIL PROTECTED]>: > Is there a way to make Postgresql case-INSENSITIVE?
It already is. portfolio=# select * from stocks limit 1; symbol | description | exchange --------+-------------+---------- AADBX | AADBX | NYSE (1 row) portfolio=# sELeCT * FROM STOCKS LIMIT 1; symbol | description | exchange --------+-------------+---------- AADBX | AADBX | NYSE (1 row) Those queries were cased differently, but were recognized as being functionally identical. -- output = ("aa454" "@" "freenet.carleton.ca") http://cbbrowne.com/info/linux.html debugging, v: Removing the needles from the haystack. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]