Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Дата
Msg-id 8937.1526921696@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics  (Alexey Dokuchaev <danfe@nsu.ru>)
Ответы Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Список pgsql-general
Alexey Dokuchaev <danfe@nsu.ru> writes:
> Quick reality check
> question: are count(*) vs. count(_) equivalent above?

Only if _ is guaranteed non-null ... which, as a rowtype result, it
probably is.  But I'd use count(*) if you're concerned about speed.

            regards, tom lane


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