Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords
Date
Msg-id 22710.1182874288@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Arrange for quote_identifier() and pg_dump to not quote keywords  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> Also, the fact that this particular form of the grammar requires
>> reserving the keywords does not prove that there is no way to have the
>> features without that.  I'd want to see us try a little harder first.

> At least some of them are unavoidable conflicts:

> select a,b,count(*) from tab GROUP BY cube(a,b)
> select a,b,count(*) from tab GROUP BY rollup(a,b)

In principle this case could be handled by having parse analysis
treat a FuncCall node at the top level of GROUP BY specially when
the function name is CUBE etc.

I'm not saying that might not be uglier than having the grammar
recognize it, just pointing out that there's usually more than
one way to skin a cat.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] New Zealand - TZ change
Next
From: "Andrew Hammond"
Date:
Subject: Re: Bugtraq: Having Fun With PostgreSQL