I tried to append an one dimensional array to a two dimensional array using array_append in psql function. I defined count_values
as output by out count_values integer[][]
, cout_value
as variable in declare section by count_value integer[]
, and tried to use count_values := array_append(count_values, count_value)
, but the error function array_append(integer[], integer[]) does not exist
poped up.
if ...
else
count_value:= array_append(count_value, 0);
end if;
index:= index + 1;
end loop;
count_values:= array_append(count_values, count_value);
end loop;
...