4 SELECT num_nonnulls(NULL);
10 SELECT num_nonnulls('1');
16 SELECT num_nonnulls(NULL::text);
22 SELECT num_nonnulls(NULL::text, NULL::int);
28 SELECT num_nonnulls(1, 2, NULL::text, NULL::point, '', int8 '9', 1.0 / NULL);
34 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
40 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
46 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i));
52 SELECT num_nulls(NULL);
58 SELECT num_nulls('1');
64 SELECT num_nulls(NULL::text);
70 SELECT num_nulls(NULL::text, NULL::int);
76 SELECT num_nulls(1, 2, NULL::text, NULL::point, '', int8 '9', 1.0 / NULL);
82 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
88 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
94 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i));
101 SELECT num_nonnulls(VARIADIC NULL::text[]);
107 SELECT num_nonnulls(VARIADIC '{}'::int[]);
113 SELECT num_nulls(VARIADIC NULL::text[]);
119 SELECT num_nulls(VARIADIC '{}'::int[]);
125 -- should fail, one or more arguments is required
126 SELECT num_nonnulls();
127 ERROR: function num_nonnulls() does not exist
128 LINE 1: SELECT num_nonnulls();
130 HINT: No function matches the given name and argument types. You might need to add explicit type casts.
132 ERROR: function num_nulls() does not exist
133 LINE 1: SELECT num_nulls();
135 HINT: No function matches the given name and argument types. You might need to add explicit type casts.