From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers <pgsql-committers(at)postgresql(dot)org> |
Subject: | Re: pgsql: Allow empty target list in SELECT. |
Date: | 2014-10-22 20:13:14 |
Message-ID: | CAA-aLv47DpdU5HToNQGuw6Zh74BXU3poACW=nH_FK4qmc73N+w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
On 22 October 2014 22:06, Thom Brown <thom(at)linux(dot)com> wrote:
> On 22 October 2014 21:57, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Thom Brown <thom(at)linux(dot)com> writes:
>> > On 15 December 2013 02:23, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> >> Allow empty target list in SELECT.
>>
>> > This commit introduces another bug:
>>
>> > # create table colours (id serial, name text, visible boolean);
>> > CREATE TABLE
>>
>> > # insert into colours (name, visible) values
>> >
>> ('blue',true),('yellow',true),('ultraviolet',false),('green',true),('infrared',false);
>> > INSERT 0 5
>>
>> > # select into colours2 from colours;
>> > SELECT 5
>>
>> > # select * from colours2;
>> > (No rows)
>>
>> That's just a pre-existing issue in psql that it's not terribly smart
>> about displaying zero-column rows. But what psql are you using?
>> I see
>>
>> regression=# select * from colours2;
>> --
>> (5 rows)
>>
>
> I'm using the one I built along with everything else:
>
> $ which psql
> /home/thom/Development/psql/bin/psql
>
I can see the same output as you if I get it to ignore my .psqlrc file:
# select * from colours2;
--
(5 rows)
Turns out it's "\x auto" causing it.
--
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-10-22 20:19:10 | Re: pgsql: Allow empty target list in SELECT. |
Previous Message | Thom Brown | 2014-10-22 20:06:14 | Re: pgsql: Allow empty target list in SELECT. |