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

From Tatsuo Ishii
Subject Re: [HACKERS] select + order by
Date
Msg-id 199905180147.KAA17929@srapc451.sra.co.jp
Whole thread Raw
In response to Re: [HACKERS] select + order by  (jwieck@debis.com (Jan Wieck))
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.

Getting latest sources and doing initdb solved the problem.

Thanks and sorry for the confusion.
---
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] DROP TABLE leaks file descriptors
Next
From: Bruce Momjian
Date:
Subject: Current TODO list