Re: pgsql: Allow empty target list in SELECT.

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

--
Thom