Обсуждение: 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 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) #