4 ms·

Postgres lets you define your own aggregate functions and has an array type. http://mssql-to-postgresql.blogspot.com/2007/12/cool-groupconcat.html http://mssql-

Postgres lets you define your own aggregate functions and has an array type. http://mssql-to-postgresql.blogspot.com/2007/12/cool-groupconcat.html http://mssql-to-postgresql.blogspot.com/2007/12/cool-groupco...

figital 17y ago
Thanks for the link. Looking forward to trying the array approach as well.
neilc 17y ago
Note that the array_accum user-defined agg described by that blog post is built into PostgreSQL 8.4 (it's called array_agg(), per the SQL standard).