On 22 October 2014 22:06, Thom Brown <[email protected]> wrote: > On 22 October 2014 21:57, Tom Lane <[email protected]> wrote: > >> Thom Brown <[email protected]> writes: >> > On 15 December 2013 02:23, Tom Lane <[email protected]> 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
