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

From Thom Brown
Subject Re: pgsql: Allow empty target list in SELECT.
Date
Msg-id CAA-aLv5tWq8TOQZ=AZv3sam9RoTAA05yecLDXqzROjxDxsHMKA@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Allow empty target list in SELECT.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-committers
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.

Thanks.

--
Thom

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: Revert commit 843cd0bfe6246d94d9b34a7f36bbb76fdba87b74
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Fix gram.y comment to match reality