/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | text.sql | 94 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 D | misc_functions.sql | 20 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | misc_functions.sql | 10 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 D | rt_mapalgebrafct.sql | 11 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 …]
|