push array to array

From: Tjibbe <tjibbe(at)rijpma(dot)org>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: push array to array
Date: 2016-09-18 16:46:10
Message-ID: CAF_dx11uKCXmaxMpYd42wxh1iRmFsbJx-t-HTDeaXybdX88vcQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to push an array at the end of an array. Like:
'{{4,5},{8,3}}' + '{3,6}' > '{{4,5},{8,3},{3,6}}'

Is there an easy way to do? (i have version "9.1.23" on my shared hosting)

Now I have written a complex function with EXECUTE command-string...

CREATE OR REPLACE FUNCTION push_2d_array(numeric[],numeric[]) RETURNS
numeric[] AS $$
DECLARE
_str text;
_arr numeric[];
BEGIN
IF $1 IS NULL THEN
RETURN ARRAY[$2];
ELSE
_str := 'SELECT ARRAY[';
FOR i in 1..array_upper($1,1) LOOP
IF i > 1 THEN _str := _str || ','; END IF;
_str := _str || 'ARRAY[' || $1[i][1] || ',' || $1[i][2] || ']';
END LOOP;
_str := _str || ', ARRAY[' || $2[1] || ',' || $2[2] || ']]';
EXECUTE _str INTO _arr ;
RETURN _arr;
END IF;
END
$$ LANGUAGE plpgsql;

--
+31 6 29401726
tjibbe(at)rijpma(dot)org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2016-09-18 17:12:53 Re: push array to array
Previous Message Andomar 2016-09-18 11:17:15 SO question about disappearing row