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@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.