projects
/
fusionforge
/
fusionforge.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
project home
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Update post-receive-email to latest version
[fusionforge/fusionforge.git]
/
src
/
db
/
20111009-string-aggregate-function.sql
1
CREATE OR REPLACE FUNCTION ff_string_add (t1 text, t2 text)
2
RETURNS text
3
AS $$
4
BEGIN
5
RETURN t1 || ' ioM0Thu6_fieldseparator_kaeph9Ee ' || t2 ;
6
END;
7
$$ LANGUAGE plpgsql
8
IMMUTABLE
9
RETURNS NULL ON NULL INPUT;
10
11
CREATE AGGREGATE ff_string_agg (
12
basetype = text,
13
sfunc = ff_string_add,
14
stype = text
15
);