Case sensitive field names - Mailing list pgsql-hackers

From Jarmo Paavilainen
Subject Case sensitive field names
Date
Msg-id 000a01c0278c$f967ad80$1501a8c0@theboss.comder.private
Whole thread Raw
List 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



pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: byacc problem with FreeBSD ...
Next
From: devik@cdi.cz
Date:
Subject: pgsql is 75 times faster with my new index scan