I have created a text concatenation function
CREATE OR REPLACE FUNCTION commacat(acc text, instr text) RETURNS text
x := trim(both from acc);
IF char_length(x) < 1 THEN
RETURN instr || ', ' || x;
Which when called works as expected.
SELECT commacat(' ','z')
I have created an aggregate which calls the function.
CREATE AGGREGATE textcat_all (text)(
SFUNC = commacat,
STYPE = text,
INITCOND = ''
But when called does not produce expected results
create temporary table x (y text);
insert into x values(' ');
insert into x values('abc');
insert into x values('def');
insert into x values('');
insert into x values('z');
> Query returned successfully: 1 row affected, 15 ms execution time.
select textcat_all(y) from x;
> "z, , def, abc"
I cannot find what it is that I am doing wrong.
Version string PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu,
compiled by GCC gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit
pgsql-novice by date
|Next:||From: Thom Brown||Date: 2011-10-13 10:04:24|
|Subject: Re: Aggregate not working as expected|
|Previous:||From: Aleksej Trofimov||Date: 2011-10-13 08:26:36|
|Subject: Re: Query planner and variables with constraint_exclusion|