Re: [HACKERS] select + order by

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] select + order by
Date: 1999-05-17 00:50:19
Message-ID: 199905170050.JAA00615@ext16.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
---
Tatsuo Ishii

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-05-17 00:57:40 GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)
Previous Message Bruce Momjian 1999-05-17 00:31:43 Open 6.5 items