"Tom Lane" <[EMAIL PROTECTED]> writes: > In short, lots of downsides here, and not a whole lot of upside.
I highly doubt the spec would ever conflict with allowing the user to elide the aliases given that Oracle (and others?) have always allowed this. Moreover if it's been 15 years without them adding it surely that argues we can be pretty sure they won't add them? This seems like a particularly petty case compared to a lot of other extensions we do allow. Surely allowing arbitrary expressions in GROUP BY is far more likely to conflict in the future given how it constrains our grammar. And in theory that provides no added functionality over aside from programmer convenience as well. There are tons of extensions to the spec in the Postgres grammar. This would be one of the simplest safest ones. The upside is the convenience which after all is the same upside as most of our spec grammar extensions. Many many programmers are accustomed to entering ad-hoc queries of this form and forcing them to enter an alias for no purpose is just silly pedanticism from their point of view. The portability of ad-hoc queries is meaningless and if you don't refer to the alias in the query then it's truly pointless. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org