Case sensitive field names

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

Responses

Browse pgsql-hackers by date

  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 ...