| From: | "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Geoghegan <pg(at)heroku(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Marko Tiikkaja <marko(at)joh(dot)to>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: count_nulls(VARIADIC "any") |
| Date: | 2015-08-13 07:18:41 |
| Message-ID: | CACACo5SBcJnX5bSFOCKCsKvCXR2_vLeLyZk-5+E2=+3H=ae1MA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 13, 2015 at 2:19 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Wed, Aug 12, 2015 at 4:11 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Peter Geoghegan <pg(at)heroku(dot)com> writes:
>> > On Wed, Aug 12, 2015 at 10:30 AM, Alvaro Herrera
>> > <alvherre(at)2ndquadrant(dot)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...
>
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Tiikkaja | 2015-08-13 07:21:16 | Re: count_nulls(VARIADIC "any") |
| Previous Message | Pavel Stehule | 2015-08-13 07:17:44 | Re: pg_dump quietly ignore missing tables - is it bug? |