Re: push array to array

2016-09-18 19:12 GMT+02:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:

> Hi
>
>
> 2016-09-18 18:46 GMT+02:00 Tjibbe <tjibbe(at)rijpma(dot)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
>