Contents

/* 
 mysqlcompat-1.0b3
 public domain
 GROUP_CONCAT()
 Note: For DISTINCT and ORDER BY a subquery is required
*/

CREATE FUNCTION _group_concat(text, text)
RETURNS text AS $$
  SELECT CASE
    WHEN $2 IS NULL THEN $1
    WHEN $1 IS NULL THEN $2
    ELSE $1 operator(pg_catalog.||) ' ' operator(pg_catalog.||) $2
  END
$$ IMMUTABLE LANGUAGE SQL;

CREATE AGGREGATE group_concat (
	BASETYPE = text,
	SFUNC = _group_concat,
	STYPE = text
);

Version data entries

3 entries across 3 versions & 2 rubygems

Version	Path
pager-ultrasphinx-1.0.20080510	lib/ultrasphinx/postgresql/group_concat.sql
pager-ultrasphinx-1.0.20080514	lib/ultrasphinx/postgresql/group_concat.sql
ultrasphinx-1.11	lib/ultrasphinx/postgresql/group_concat.sql