| From: | Marko Tiikkaja <marko(at)joh(dot)to> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: count_nulls(VARIADIC "any") |
| Date: | 2015-11-22 20:25:21 |
| Message-ID: | 565224B1.60901@joh.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2015-11-22 21:17, Jim Nasby wrote:
> On 11/22/15 11:34 AM, Marko Tiikkaja wrote:
>> On 2015-11-22 18:29, Jim Nasby wrote:
>>> Only if you know how many columns there already are.
>>>
>>> Or does this not work if you hand it a row?
>>
>> It "works" in the sense that it tells you whether the row is NULL or
>> not. I.e. the answer will always be 0 or 1.
>
> Hrm, I was hoping something like count_nulls(complex_type.*) would work.
Nope:
=# select num_nulls((f).*) from (select '(1,2,3)'::foo) ss(f);
ERROR: row expansion via "*" is not supported here
.m
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2015-11-22 20:27:08 | Re: custom function for converting human readable sizes to bytes |
| Previous Message | Jim Nasby | 2015-11-22 20:19:11 | Re: custom function for converting human readable sizes to bytes |