Re: [GENERAL] Problem about pgsql's column alias

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: milimeter(at)163(dot)com, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Problem about pgsql's column alias
Date: 2003-04-16 14:16:49
Message-ID: 17738.1050502609@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-interfaces pgsql-jdbc

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Allowing column aliases without AS would break nothing.

... except postfix operators, and whatever else happens to get caught in
the crossfire. And we'll still get complaints because it only works for
identifiers, not for keywords.

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannu Krosing 2003-04-16 14:17:47 Re: Are we losing momentum?
Previous Message Shridhar Daithankar 2003-04-16 14:16:37 Re: Are we losing momentum?

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2003-04-16 14:17:47 Re: Are we losing momentum?
Previous Message Shridhar Daithankar 2003-04-16 14:16:37 Re: Are we losing momentum?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2003-04-16 14:23:09 Re: First draft of new FE/BE protocol spec posted for comments
Previous Message Tom Lane 2003-04-16 14:06:07 Re: [INTERFACES] First draft of new FE/BE protocol spec posted for comments

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-04-16 16:25:47 Re: [PATCHES] the build
Previous Message Peter Eisentraut 2003-04-16 13:46:36 Re: [GENERAL] Problem about pgsql's column alias