Re: [GENERAL] Problem about pgsql's column alias - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [GENERAL] Problem about pgsql's column alias
Date
Msg-id Pine.LNX.4.44.0305152059200.2756-100000@peter.localdomain
Whole thread Raw
In response to Re: [GENERAL] Problem about pgsql's column alias  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> > Allowing column aliases without AS would break nothing.
>
> Now I'll admit that the postfix-operator issue is probably a red
> herring, since "SELECT a + b, ..." should get interpreted as infix +
> in any case.  But I think there are other side-effects we have not
> fully analyzed yet.  The one-line grammar hack was not intended to
> be actually applied, right?  Let's see a complete proposal.

I have analyzed the all the grammar conflicts that the optional AS would
cause.  The real killer were these two clauses:

expr ISNULL
expr NOTNULL

I don't know how to resolve that without making ISNULL and NOTNULL more
reserved than any other word, which seems unattractive.

(The only two other areas of conflict where postfix operators and trailing
multiword type names in ::-style type casts, which we already talked
about.)

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Kurt Roeckx
Date:
Subject: Re: Win32, compiles, under, MinGW/Msys!
Next
From: Bruce Momjian
Date:
Subject: Re: Win32, compiles, under, MinGW/Msys!