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

From Jim Nasby
Subject Re: count_nulls(VARIADIC "any")
Date
Msg-id 5651FB70.9090202@BlueTreble.com
Whole thread Raw
In response to Re: count_nulls(VARIADIC "any")  (Marko Tiikkaja <marko@joh.to>)
Responses Re: count_nulls(VARIADIC "any")  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers
On 11/20/15 11:55 PM, Marko Tiikkaja wrote:
> On 2015-11-21 06:52, Jim Nasby wrote:
>> On 11/20/15 11:12 PM, Marko Tiikkaja wrote:
>>> On 2015-11-21 06:02, I wrote:
>>>> Here's a patch implementing this under the name num_nulls().  For
>>>> January's CF, of course.
>>>
>>> I forgot to update the some references in the documentation.  Fixed in
>>> v3, attached.
>>
>> I thought there was going to be a not-null equivalent as well? I've
>> definitely wanted both variations in the past.
>
> I'm not sure that's necessary.  It's quite simple to implement yourself
> using the  int - int  operator.

Only if you know how many columns there already are.

Or does this not work if you hand it a row?
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Freeze avoidance of very large table.
Next
From: Jim Nasby
Date:
Subject: Re: custom function for converting human readable sizes to bytes