Re: push array to array - Mailing list pgsql-general

2016-09-18 19:12 GMT+02:00 Pavel Stehule <pavel.stehule@gmail.com>:

Hi

2016-09-18 18:46 GMT+02:00 Tjibbe <tjibbe@rijpma.org>:

'{{4,5},{8,3}}' + '{3,6}'

postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]];
+---------------------+
|      ?column?       |
+---------------------+
| {{4,5},{8,3},{3,6}} |
+---------------------+
(1 row)

CREATE OR REPLACE FUNCTION public.array2d_append(integer[], integer[])
 RETURNS integer[]
 LANGUAGE sql
AS $function$
SELECT COALESCE($1 || ARRAY[$2], $1, $2);
$function$

postgres=# SELECT array2d_append('{{4,5},{8,3}}', '{3,6}');
+---------------------+
|   array2d_append    |
+---------------------+
| {{4,5},{8,3},{3,6}} |
+---------------------+
(1 row)

 

regards

Pavel