Re: pgsql: Allow empty target list in SELECT.

On 25 March 2015 at 01:04, Bruce Momjian <bruce@momjian.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.