From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | t-ishii(at)sra(dot)co(dot)jp |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] select + order by |
Date: | 1999-05-17 01:01:24 |
Message-ID: | 199905170101.VAA20770@candle.pha.pa.us |
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.
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-05-17 01:15:01 | Re: [HACKERS] v6.5 release ToDo |
Previous Message | Tom Lane | 1999-05-17 00:57:40 | GEQO optimizer (was Re: Backend message type 0x44 arrived while idle) |