Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics - Mailing list pgsql-general

From Tom Lane
Subject Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Date
Msg-id 8937.1526921696@sss.pgh.pa.us
Whole thread Raw
In response to Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics  (Alexey Dokuchaev <danfe@nsu.ru>)
Responses Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
List pgsql-general
Tree view 
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 by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?
Next
From: Alexey Dokuchaev
Date:
Subject: Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics