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.0304141455000.1919-100000@peter.localdomain
Whole thread Raw
Responses Re: [GENERAL] Problem about pgsql's column alias  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> AS is not optional in Postgres, and will never be so unless we choose to
> drop support for postfix operators, which I consider an unlikely choice.

Well, we could drop the support for postfix operators in aliasing clauses
that omit the AS.  In fact, I got the following to work with no further
changes:

target_el: a_expr AS ColLabel          | c_expr IDENT  // new          | a_expr          | '*'

If we wanted more than IDENT, we would need to trade off some key words in
(few) other places, but it looks doable.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: terr@terralogic.net
Date:
Subject: Re: No merge sort?
Next
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: No merge sort?