Contents

/* Taken from ultrasphinx */

/* 
 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 COALESCE($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

2 entries across 2 versions & 1 rubygems

Version	Path
minisphinx-1.0.1	lib/mysqlcompat/group_concat.sql
minisphinx-1.0.0	lib/mysqlcompat/group_concat.sql