Re: PostgreSQL Gotchas - Mailing list pgsql-general

From Jan Wieck
Subject Re: PostgreSQL Gotchas
Date
Msg-id 4353B01A.5050201@Yahoo.com
Whole thread Raw
In response to Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 10/16/2005 12:40 PM, Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> Actually, perhaps an even more restricted version would be better.
>> Lowercase quoted identifiers only if they are all uppercase. So then:
>
> No, I think the original proposal was better.  This one doesn't fix
> things for the lusers who think "MixedCase" and unquoted MixedCase
> should be the same.

What is bad about leaving pg_catalog all lower case and expect everyone
to query the catalog quoted? We would be totally free as to the
flexibility of the new option. One setting could even act 100% according
to the standard ... a feature I'm missing so far in all the proposals.


Jan

>
>> Note to implementor: In 'SELECT 1 as "Title"', the quoted string should
>> not be lowercased, even if you are lowercasing everything else...
>
> You don't get to have that, I think, because the lexer is not context
> aware.  It's not clear to me why it's a good idea anyway.
>
>             regards, tom lane


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

pgsql-general by date:

Previous
From: "Cristian Prieto"
Date:
Subject: Re: dynamic loading of .so
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL Gotchas