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)
regards, tom lane
--
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
