Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"?
Дата
Msg-id CAKFQuwbOAfLm5zaZ03Fk8sQ2yU1jNX0RGQUeP9knGat+BHU=6A@mail.gmail.com
обсуждение исходный текст
Ответ на "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Wednesday, February 1, 2023, Ron <ronljohnsonjr@gmail.com> wrote:

test=# select  from sales_detail;
--
(11 rows)

It returned 11 rows as per the psql output text, if it acted like count(*), an aggregate, it would have only returned one row.

You have produced an 11-row, 0-column, output table.  It isn’t “supported” but is allowed for technical convenience, hence the decision to avoid trying to communicate this fact in the syntax diagram.

David J.

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

Предыдущее
От: Rodrigo Luna
Дата:
Сообщение: Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"?