Re: [HACKERS] select + order by - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] select + order by
Date
Msg-id m10jJ7e-000EBZC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [HACKERS] select + order by  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] select + order by  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
>
> > > >   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) #

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Misleading Error Message
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] rules regression test