From: | "Jarmo Paavilainen" <netletter(at)comder(dot)com> |
---|---|
To: | "PostgreSQL Hackers" <pgsql-hackers(at)hub(dot)org> |
Subject: | Case sensitive field names |
Date: | 2000-09-26 07:39:59 |
Message-ID: | 000a01c0278c$f967ad80$1501a8c0@theboss.comder.private |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
Is there a way to make postgre insensitive about field name cases?
Like "initdb --fields-are-case-insensitive --compares-are-case-insensitive"
Yes I know about "CaseIsKept" and CaseIsNotKept (note the quotes). But that
gives me more trouble than it solves. And what about "case insensitive field
name with spaces". I believe that space is legal in field names.
Are there any real reason why postgre is sensitive about field names (except
SQL92 states that this is how it must be)?
I suppose somewhere along the way I have all field names separated from the
query, and in which file(s) does that happen? (So I can do my own hack, add
"tolower(fieldName)").
Ive tried to locate the right files in the source for 7.0.2, but there are
more that one file.
// Jarmo
From | Date | Subject | |
---|---|---|---|
Next Message | devik | 2000-09-26 09:15:28 | pgsql is 75 times faster with my new index scan |
Previous Message | The Hermit Hacker | 2000-09-25 22:03:13 | Re: byacc problem with FreeBSD ... |