From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Case Preservation disregarding case |
Date: | 2006-12-02 15:21:08 |
Message-ID: | 457199E4.3010401@kensystem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Martijn van Oosterhout wrote:
> On Sat, Dec 02, 2006 at 12:41:37AM -0700, Ken Johanson wrote:
>> 1: It seems like this behavior of case sensitive-or-not-identifiers
>> could/should be a config option -- either globally for the server,
>> database, or at the connection/session level. Other databases *do*
>> support this type of granular config of misc SQL behavior -- its
>> essential for shared hosting environments. Without it some users just
>> *cant* make the switch. Quoting all an app's identifiers -- or renaming
>> camel-case to underscored -- show stopper.
>
> What about option 3: use camelcase without underscares and don't quote.
> Then you get case-insensetivity and it's still readable.
>
> You're obviously talking about an app which isn't quoting identifiers,
> so I'm not sure what the actual problem is.
>
> Have a nice day,
Yes, I do routinely use non-quoted identifiers. The problem is, that
they are case-folded (to lower in PG's case), so my camel-case does not
match. For the query to work I MUST quote identifiers hat have camel-case.
SELECT
pers."firstName",
pers.lastname,
...
Has your experience with PG been different? If so I presume you have
have found a config that allows?:
SELECT
pers.firstName,
pers.lastname,
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Bjorklund | 2006-12-02 16:02:55 | Re: [HACKERS] Case Preservation disregarding case |
Previous Message | Martijn van Oosterhout | 2006-12-02 13:35:56 | Re: [SQL] Case Preservation disregarding case |
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Bjorklund | 2006-12-02 16:02:55 | Re: [HACKERS] Case Preservation disregarding case |
Previous Message | Martijn van Oosterhout | 2006-12-02 13:35:56 | Re: [SQL] Case Preservation disregarding case |