Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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