select * from stocks where lower(symbol) = 'aadbx'; or select * from stocks where symbol ilike =aadbx'; or select * from stocks where symbol ~* 'aadbx';
HTH Darren On Sat, 13 Sep 2003, Relaxin wrote: > 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] > -- Darren Ferguson ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
