Re: case-insensitive database

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