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

From Alexey Dokuchaev
Subject Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Date
Msg-id 20180521172435.GA12264@regency.nsu.ru
Whole thread Raw
In response to Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, May 21, 2018 at 12:54:56PM -0400, Tom Lane wrote:
> 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.

Understood.  Yes, my primary concern (after correctness) is speed.  Thank
you all again for very helpful and prompt replies guys.

./danfe


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?
Next
From: "Bartosz Dmytrak"
Date:
Subject: posgresql.log