Re: pgsql: Allow empty target list in SELECT.

On 25 March 2015 at 01:04, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Fri, Mar 20, 2015 at 08:25:50AM -0400, Bruce Momjian wrote:
> > > regression=# create table foo();
> > > CREATE TABLE
> > > regression=# insert into foo default values;
> > > INSERT 0 1
> > > regression=# insert into foo default values;
> > > INSERT 0 1
> > > regression=# select * from foo;
> > > --
> > > (2 rows)
> > >
> > > regression=# \x on
> > > Expanded display is on.
> > > regression=# select * from foo;
> > > (No rows)
> >
> > I have developed a patch to fix this, e.g.:
> >
> > test=> select * from foo;
> > --
> > (2 rows)
> >
> > test=> \x
> > Expanded display is on.
> > test=> select * from foo;
> > (2 rows)
> >
> > I used the same footer function every other output format was using.
> > Patch attached.
>
> Patch applied.
>

Thanks.

--
Thom