Re: count_nulls(VARIADIC "any") - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: count_nulls(VARIADIC "any")
Date
Msg-id CAKFQuwawJq1Sf3jLFeJAE24MmvsAdieLrxkboJU9OaTJojk3YA@mail.gmail.com
Whole thread Raw
In response to Re: count_nulls(VARIADIC "any")  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: count_nulls(VARIADIC "any")  ("Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>)
List pgsql-hackers
On Wed, Aug 12, 2015 at 4:11 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Peter Geoghegan <pg@heroku.com> writes:
> On Wed, Aug 12, 2015 at 10:30 AM, Alvaro Herrera
> <alvherre@2ndquadrant.com> wrote:
>> The name count_nulls() suggest an aggregate function to me, though.

> I thought the same.

Ditto.  I'd be fine with this if we can come up with a name that
doesn't sound like an aggregate.  The best I can do offhand is
"number_of_nulls()", which doesn't seem very pretty.


nulls_in(a, b, c) IN (0, 3) - yes the repetition is not great...

David J.
 

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Macro nesting hell
Next
From: Michael Paquier
Date:
Subject: Re: WIP: SCRAM authentication