Home
last modified time | relevance | path

Searched refs:VARIADIC (Results 1 – 25 of 1299) sorted by relevance

12345678910>>...52

/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Dtext.sql94 concat(VARIADIC ARRAY[1, 2, 3]);
97 concat_ws(',', VARIADIC ARRAY[1, 2, 3]);
100 concat_ws(',', VARIADIC NULL::int[]);
103 concat(VARIADIC NULL::int[]) IS NULL;
106 concat(VARIADIC '{}'::int[]) = '';
110 concat_ws(',', VARIADIC 10);
193 format('%s, %s', VARIADIC ARRAY['Hello', 'World']);
196 format('%s, %s', VARIADIC ARRAY[1, 2]);
199 format('%s, %s', VARIADIC ARRAY[TRUE, FALSE]);
209 format('%2$s, %1$s', VARIADIC ARRAY[1, 2]);
[all …]
H A Dmisc_functions.sql20 num_nonnulls (VARIADIC '{1,2,NULL,3}'::int[]);
23 num_nonnulls (VARIADIC '{"1","2","3","4"}'::text[]);
26 num_nonnulls (VARIADIC ARRAY (
49 num_nulls (VARIADIC '{1,2,NULL,3}'::int[]);
52 num_nulls (VARIADIC '{"1","2","3","4"}'::text[]);
55 num_nulls (VARIADIC ARRAY (
64 num_nonnulls (VARIADIC NULL::text[]);
67 num_nonnulls (VARIADIC '{}'::int[]);
70 num_nulls (VARIADIC NULL::text[]);
73 num_nulls (VARIADIC '{}'::int[]);
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Dmisc_functions.sql10 SELECT num_nonnulls(VARIADIC '{1,2,NULL,3}'::int[]);
11 SELECT num_nonnulls(VARIADIC '{"1","2","3","4"}'::text[]);
12 SELECT num_nonnulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100)…
19 SELECT num_nulls(VARIADIC '{1,2,NULL,3}'::int[]);
20 SELECT num_nulls(VARIADIC '{"1","2","3","4"}'::text[]);
21 SELECT num_nulls(VARIADIC ARRAY(SELECT CASE WHEN i <> 40 THEN i END FROM generate_series(1, 100) i)…
24 SELECT num_nonnulls(VARIADIC NULL::text[]);
25 SELECT num_nonnulls(VARIADIC '{}'::int[]);
26 SELECT num_nulls(VARIADIC NULL::text[]);
27 SELECT num_nulls(VARIADIC '{}'::int[]);
/dports/databases/postgis32/postgis-3.2.0/raster/test/regress/
H A Drt_mapalgebrafct.sql11 CREATE OR REPLACE FUNCTION raster_plus_twenty(pixel FLOAT, VARIADIC args TEXT[])
20 CREATE OR REPLACE FUNCTION raster_plus_arg1(pixel FLOAT, VARIADIC args TEXT[])
34 CREATE OR REPLACE FUNCTION raster_polynomial(pixel FLOAT, VARIADIC args TEXT[])
52 CREATE OR REPLACE FUNCTION raster_nullage(pixel FLOAT, VARIADIC args TEXT[])
61 CREATE OR REPLACE FUNCTION raster_x_plus_arg(pixel FLOAT, pos INT[], VARIADIC args TEXT[])
126 DROP FUNCTION raster_plus_twenty(pixel FLOAT, VARIADIC args TEXT[]);
127 DROP FUNCTION raster_plus_arg1(pixel FLOAT, VARIADIC args TEXT[]);
128 DROP FUNCTION raster_polynomial(pixel FLOAT, VARIADIC args TEXT[]);
129 DROP FUNCTION raster_nullage(pixel FLOAT, VARIADIC args TEXT[]);
130 DROP FUNCTION raster_x_plus_arg(pixel FLOAT, pos INT[], VARIADIC args TEXT[]);
[all …]

12345678910>>...52