Re: count_nulls(VARIADIC "any")

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: count_nulls(VARIADIC "any")
Date: 2015-11-21 05:11:30
Message-ID: 564FFD02.6010600@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2015-11-21 06:06, Tom Lane wrote:
> Marko Tiikkaja <marko(at)joh(dot)to> writes:
>> Here's a patch implementing this under the name num_nulls(). For
>> January's CF, of course.
>
> What's this do that "count(*) - count(x)" doesn't?

This is sort of a lateral version of count(x); the input is a list of
expressions rather than an expression executed over a bunch of input rows.

.m

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2015-11-21 05:12:36 Re: count_nulls(VARIADIC "any")
Previous Message Tom Lane 2015-11-21 05:06:25 Re: count_nulls(VARIADIC "any")