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 CAKFQuwb1ZRNwcdCaKvmzv3AgZLR87kDt3coWAqXeE+xNSwTRhA@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:

https://www.postgresql.org/docs/12/sql-select.html

The docs say that one of these are required in the SELECT list.
[ * | expression [ [ AS ] output_name ] [, ...] ]

The square brackets you show are how optional elements are introduced so while those two options exists neither are required.

David J. 

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

Предыдущее
От: Rodrigo Luna
Дата:
Сообщение: Re: FATAL: database "xxx" does not exist when it does
Следующее
От: Rodrigo Luna
Дата:
Сообщение: Re: FATAL: database "xxx" does not exist when it does