Re: pgsql: Allow empty target list in SELECT. - Mailing list pgsql-committers

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.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +