Re: case-insensitive database

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: case-insensitive database
Дата
Msg-id m3u17gsxhe.fsf@chvatal.cbbrowne.com
обсуждение исходный текст
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Relaxin"
Дата:
Сообщение: Re: case-insensitive database
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: need for in-place upgrades (was Re: State of