By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
select version();
create function f(count_values integer[][]) returns integer[][]
as $$
declare
count_value integer[] = '{5,6}';
-- count_values integer[][] ;
new_cvs integer[][];
begin
if count_values is null
then new_cvs = array_cat(ARRAY[]::integer[][],ARRAY[count_value]);
else new_cvs = Array_cat(count_values,count_value);
end if ;
return new_cvs;
end; $$
language plpgsql;
Select f(null::integer[][]),f(f(null::integer[][]));
| version |
|---|
| PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit |
SELECT 1
CREATE FUNCTION
| f | f |
|---|---|
| {{5,6}} | {{5,6},{5,6}} |
SELECT 1