Обсуждение: Re: case-insensitive database

Поиск
Список
Период
Сортировка

Re: case-insensitive database

От
Christopher Browne
Дата:
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.