Thread

1. Re: [HACKERS] Some progress on INSERT/SELECT/GROUP BY bugs

   Zeugswetter Andreas <andreas.zeugswetter@telecom.at> — 1999-05-19T11:36:26Z

   > 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
   
   

2. Re: [HACKERS] Some progress on INSERT/SELECT/GROUP BY bugs

   Jan Wieck <jwieck@debis.com> — 1999-05-19T15:08:42Z

   >
   > > 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) #