Re: case-insensitive database - Mailing list pgsql-general

From Christopher Browne
Subject Re: case-insensitive database
Date
Msg-id m3u17gsxhe.fsf@chvatal.cbbrowne.com
Whole thread Raw
List 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 by date:

Previous
From: "Relaxin"
Date:
Subject: Re: case-insensitive database
Next
From: Christopher Browne
Date:
Subject: Re: need for in-place upgrades (was Re: State of