João Arthur Juaçaba Moreira joao-arthur-moreira

Analyst developer of corporate systems, focusing on Delphi and Java languages, SQL Server databases, Postgres, MySQL and MongoDB.

joao-arthur-moreira / group_concat.sql

Created August 8, 2017 20:09 — forked from aaronpuchert/group_concat.sql

This is a group_concat(int) replacement for PostgreSQL.

	CREATE OR REPLACE FUNCTION group_concat_iterate(_state INTEGER[], _value INTEGER)
	RETURNS INTEGER[] AS
	$BODY$
	SELECT
	CASE
	WHEN $1 IS NULL THEN ARRAY[$2]
	ELSE $1 \|\| $2
	END
	$BODY$
	LANGUAGE SQL VOLATILE;