Re: [HACKERS] What can we learn from MySQL? - Mailing list pgsql-advocacy

From Tom Lane
Subject Re: [HACKERS] What can we learn from MySQL?
Date
Msg-id 8160.1082785627@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] What can we learn from MySQL?  (Dennis Bjorklund <db@zigo.dhs.org>)
Responses Re: [HACKERS] What can we learn from MySQL?  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-advocacy
Dennis Bjorklund <db@zigo.dhs.org> writes:
> On Sat, 24 Apr 2004, Tom Lane wrote:
>> So what I'm holding out for is a design that lets me continue to see the
>> current behavior if I set a GUC variable that says that's what I want.

> Wouldn't the upper case identifiers just be visible in the \d output,
> table headers and such.

Exactly ... and that's where my readability complaint starts ...

> First I thought that one can store the string with case all the time, and
> just convert when needed (when comparing identifiers).

People keep suggesting these random not-quite-standard behaviors, but
I fail to see the point.  Are you arguing for exact standards
compliance, or not?  If you're not, then you have to make your case on
the claim that "my nonstandard behavior is better than the existing
nonstandard behavior".  Which might be true, beauty being in the eye of
the beholder, but I doubt you can prove it to the extent of overriding
the backwards-compatibility issue.

            regards, tom lane

pgsql-advocacy by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: [HACKERS] What can we learn from MySQL?
Next
From: Dennis Bjorklund
Date:
Subject: Re: [HACKERS] What can we learn from MySQL?