Case insensitivity, and option?

From: mlw <pgsql(at)mohawksoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Case insensitivity, and option?
Date: 2003-03-12 14:03:26
Message-ID: 3E6F3E2E.5000808@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2003-03-12 14:32:45 Re: Roadmap for FE/BE protocol redesign
Previous Message mlw 2003-03-12 13:58:25 Re: Numbering of the next release: 8.0 vs 7.4