Re: pgsql: Allow empty target list in SELECT.

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: pgsql: Allow empty target list in SELECT.
Дата
Msg-id CAA-aLv47DpdU5HToNQGuw6Zh74BXU3poACW=nH_FK4qmc73N+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Allow empty target list in SELECT.  (Thom Brown <thom@linux.com>)
Ответы Re: pgsql: Allow empty target list in SELECT.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
On 22 October 2014 22:06, Thom Brown <thom@linux.com> wrote:
On 22 October 2014 21:57, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thom Brown <thom@linux.com> writes:
> On 15 December 2013 02:23, Tom Lane <tgl@sss.pgh.pa.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

I can see the same output as you if I get it to ignore my .psqlrc file:

# select * from colours2;
--
(5 rows)

Turns out it's "\x auto" causing it.

--
Thom

В списке pgsql-committers по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: pgsql: Allow empty target list in SELECT.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Allow empty target list in SELECT.