ryandotsmith/agg.sql

Created January 23, 2013 05:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ryandotsmith/4602274.js"></script>
Save ryandotsmith/4602274 to your computer and use it in GitHub Desktop.

Download ZIP

Postgres array concatenation aggregate function.

Raw

agg.sql

	CREATE AGGREGATE array_accum (anyarray)
	(
	sfunc = array_cat,
	stype = anyarray,
	initcond = '{}'
	);

WhereRtheInterwebs commented Apr 22, 2023 •

edited

Loading

This is great! Is it possible to adapt this so that you can make the array items distinct?
Example of what I'm thinking:
array_accum(distinct "duplicateList")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment