Re: [GENERAL] push array to array

2016-09-18 Thread Pavel Stehule
2016-09-18 19:15 GMT+02:00 Pavel Stehule : > > > 2016-09-18 19:12 GMT+02:00 Pavel Stehule : > >> Hi >> >> >> 2016-09-18 18:46 GMT+02:00 Tjibbe : >> >>> '{{4,5},{8,3}}' + '{3,6}' >> >> >> postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]]; >> +-+ >> | ?column? |

Re: [GENERAL] push array to array

2016-09-18 Thread Pavel Stehule
2016-09-18 19:12 GMT+02:00 Pavel Stehule : > Hi > > > 2016-09-18 18:46 GMT+02:00 Tjibbe : > >> '{{4,5},{8,3}}' + '{3,6}' > > > postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]]; > +-+ > | ?column? | > +-+ > | {{4,5},{8,3},{3,6}} | > +--

Re: [GENERAL] push array to array

2016-09-18 Thread Pavel Stehule
Hi 2016-09-18 18:46 GMT+02:00 Tjibbe : > '{{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) regards Pavel