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" <cbbrowne@acm.org> wrote in message
news:m3u17gsxhe.fsf@chvatal.cbbrowne.com...
> Quoth "Relaxin" <noname@spam.com>:
> > 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.
