From: | Michael W Mitton <mmitton(at)ssi-c(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Runtime Config Option for identifier case preservation |
Date: | 2005-01-14 19:51:08 |
Message-ID: | 200501141451.08412.mmitton@ssi-c.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Attached is a patch to allow the user to change the behavior of postgres with
reguards to case sensitivity on unquoted identifiers. This does not change
the default behavior of converting unquoted identifiers to lowercase, but
does allow (for instance, and I'm absolutly -not- pulling from personal
experience here <g>) a large project to run under postgres that did run under
MySQL a whole bunch easier.
for example, these two SQL statements sets are identical
set parser-ignore-case = false;
select "Address_id" from "Address";
set parser-ignore-case = true;
select Address_id from Address;
Attachment | Content-Type | Size |
---|---|---|
pg-parser-ignore-case.patch | text/x-diff | 2.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael W Mitton | 2005-01-14 20:10:31 | Re: Runtime Config Option for identifier case preservation |
Previous Message | Tom Lane | 2005-01-14 17:54:00 | Re: Minor comment correction |