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

From Tom Lane
Subject Re: [HACKERS] select + order by
Date
Msg-id 18290.926863661@sss.pgh.pa.us
Whole thread Raw
In response to select + order by  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] select + order by
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> But
>     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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] How good is FreeBSD for postgres ?
Next
From: Vazsonyi Peter
Date:
Subject: Re: [HACKERS] Re: sequences vs. transactions