Re: GROUP BY column alias? - Mailing list pgsql-general

From Tom Lane
Subject Re: GROUP BY column alias?
Date
Msg-id 7803.1266607478@sss.pgh.pa.us
Whole thread Raw
In response to Re: GROUP BY column alias?  (David Fetter <david@fetter.org>)
List pgsql-general
David Fetter <david@fetter.org> writes:
> On Fri, Feb 19, 2010 at 12:07:42AM -0500, Tom Lane wrote:
>> SQL:1999 and later use a slightly different definition which is not
>> entirely upward compatible with SQL-92. In most cases, however,
>> PostgreSQL will interpret an ORDER BY or GROUP BY expression the
>> same way SQL:1999 does.

> The current SQL standard *supersedes* all previous ones.

That is the opinion of the SQL committee, all right, but it has got
precious little to do with the real world.

            regards, tom lane

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: GROUP BY column alias?
Next
From: Vick Khera
Date:
Subject: Re: Doubts about oid