Thread

1. Re: [HACKERS] select + order by

   Tatsuo Ishii <t-ishii@sra.co.jp> — 1999-05-17T00:50:19Z

   > > 	select usename as aaa from pg_user order by usename;
   > > will produce 2 column names: "aaa" and "usename". Is this normal?
   > 
   > No.  I am not seeing it here with sources from 12 May.  I am guessing
   > this has something to do with Jan's recent fixes for group by/order by
   > rewrites.  Do you see it when you use a plain table, rather than a view?
   
   I see it with a plain table too.
   ---
   Tatsuo Ishii
   
   

2. Re: [HACKERS] select + order by

   Bruce Momjian <maillist@candle.pha.pa.us> — 1999-05-17T01:01:24Z

   > > > 	select usename as aaa from pg_user order by usename;
   > > > will produce 2 column names: "aaa" and "usename". Is this normal?
   > > 
   > > No.  I am not seeing it here with sources from 12 May.  I am guessing
   > > this has something to do with Jan's recent fixes for group by/order by
   > > rewrites.  Do you see it when you use a plain table, rather than a view?
   > 
   > I see it with a plain table too.
   
   I just did a make clean, initdb, etc, and got:
   
   	test=> select usename as aaa from pg_user order by usename;
   	aaa     
   	--------
   	postgres
   	(1 row)
   
   Looks good to me.
   
   
   -- 
     Bruce Momjian                        |  http://www.op.net/~candle
     maillist@candle.pha.pa.us            |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
   
   

3. Re: [HACKERS] select + order by

   Jan Wieck <jwieck@debis.com> — 1999-05-17T08:51:42Z

   >
   > > > >   select usename as aaa from pg_user order by usename;
   > > > > will produce 2 column names: "aaa" and "usename". Is this normal?
   > > >
   > > > No.  I am not seeing it here with sources from 12 May.  I am guessing
   > > > this has something to do with Jan's recent fixes for group by/order by
   > > > rewrites.  Do you see it when you use a plain table, rather than a view?
   > >
   > > I see it with a plain table too.
   >
   > I just did a make clean, initdb, etc, and got:
   >
   >    test=> select usename as aaa from pg_user order by usename;
   >    aaa
   >    --------
   >    postgres
   >    (1 row)
   >
   > Looks good to me.
   
       Yes, latest changes require a clear, intidb due to changes in
       the node out/read functions.
   
   
   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) #