No, I mean the data. select * from stocks where symbol = 'AADBX' and select * from stocks where symbol = 'aadbx'
would bring up the same result set. "Christopher Browne" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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]
