Why does array append does not work + Postgres

Question

Trying to append an array to an array does not seem to work.

DO
$do$
DECLARE
  COUNTER INTEGER = 0;
  CRNS bigint [];
  TMPS bigint [];
BEGIN
  WHILE COUNTER < 2 LOOP
    TMPS := ARRAY(select plain_crn from call_records where timestamp=1467981702966);
    array_append(CRNS,TMPS);
    RAISE NOTICE '%',CRNS;
    COUNTER := COUNTER + 1;
  END LOOP;  
END
$do$;

Seem to get the following error

ERROR:  function array_append(bigint[], bigint[]) does not exist
LINE 1: SELECT array_append(CRNS,TMPS)
           ^

klin · Accepted Answer · 2016-07-13 13:50:02Z

1

The function array_append() appends an element to an array. You should concatanate two arrays with the operator ||.

DO
$do$
DECLARE
  COUNTER INTEGER = 0;
  CRNS bigint [];
BEGIN
  WHILE COUNTER < 2 LOOP
    CRNS := CRNS || ARRAY(select plain_crn from call_records where timestamp=1467981702966);
    RAISE NOTICE '%',CRNS;
    COUNTER := COUNTER + 1;
  END LOOP;  
END
$do$;

answered Jul 13, 2016 at 13:50

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

Why does array append does not work + Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related