Case insensitivity, and option? - Mailing list pgsql-hackers

From mlw
Subject Case insensitivity, and option?
Date
Msg-id 3E6F3E2E.5000808@mohawksoft.com
Whole thread Raw
Responses Re: Case insensitivity, and option?  (Mathieu Arnold <mat@mat.cc>)
Re: Case insensitivity, and option?  (Rod Taylor <rbt@rbt.ca>)
Re: Case insensitivity, and option?  ("Ron Mayer" <ron@intervideo.com>)
List pgsql-hackers
I was at a client office reviewing some code. They use MSSQL and I 
noticed that:

select * from table where field = 'blah';
gave the same results as:
select * from table where field = 'BLah';

I was shocked. (a) because I know a lot of my code could be easier to 
write, and (b) that their code would break on every other database I am 
aware of. Does anyone know about this?

Is it practical/desirable for PostgreSQL to have this as a configuration 
setting?



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: Numbering of the next release: 8.0 vs 7.4
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: Roadmap for FE/BE protocol redesign