On Thu, Aug 13, 2015 at 2:19 AM, David G. Johnston < [email protected]> wrote:
> On Wed, Aug 12, 2015 at 4:11 PM, Tom Lane <[email protected]> wrote: > >> Peter Geoghegan <[email protected]> writes: >> > On Wed, Aug 12, 2015 at 10:30 AM, Alvaro Herrera >> > <[email protected]> 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... > How about these: nulls_rank() (the analogy being 0 <= "rank" <= "set size") nnulls() or just nulls() (this one might be a bit confusing due to existing NULLS LAST/FIRST syntax, though) -- Alex
