array_append function is not working

Question

I need to append an item to existed array in postgresql. I wrote this code (plpgsql function):

perform array_append (arrayA::integer[],id);

Since it didn't work I tried:

raise notice '%', arrayA;
perform array_append (arrayA::integer[],id);
raise notice '%', arrayA;

It gives:

NOTICE:  <NULL>
NOTICE:  <NULL>

Why the array isn't updated?

v_arraya := arraya || id or v_array := array_append(arraya, id); (that assumes that the variable arrraya is indeed an array — user330315
– user330315, Commented Dec 17, 2015 at 14:38

Elad · Accepted Answer · 2015-12-17 14:37:29Z

5

PERFORM query discard the results. array_append doesn't update the array you specify in the first parameter. It only reads the its values.

You should change your code to:

select array_append (arrayA::integer[],id) into v_arrayA;

answered Dec 17, 2015 at 14:37

Elad

8945 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

The select is not necessary, you can just assign the result to the variable.