> I still am unclear which of these are valid SQL:
> 
> 	select a as b from test order by a
> 	select a as b from test order by b
> 
Both are valid, and don't forget the third variant:

> select a as b from test order by 1
> 
Andreas

Wed, 19 May 1999 13:36:26 +0200
ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
Re: [HACKERS] Some progress on INSERT/SELECT/GROUP BY bugs
>
> > I still am unclear which of these are valid SQL:
> >
> >  select a as b from test order by a
> >  select a as b from test order by b
> >
> Both are valid, and don't forget the third variant:
>
> > select a as b from test order by 1
> >
> Andreas
>

    I  wonder  why  this  should be valid. Consider the following
    test case:

        CREATE TABLE t1 (a int4, b int4);
        SELECT a AS b, b AS a FROM t1 GROUP BY a, b;

    Is that now GROUP BY 1,2 or BY 2,1? Without the grouping,  it
    is a totally valid statement because the column DISPLAY-names
    given with AS don't affect the rest of it.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Wed, 19 May 1999 17:08:42 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] Some progress on INSERT/SELECT/GROUP BY bugs