Re: going gaga on creating an aggregate... [solved of course...] - Mailing list pgsql-sql

From Christian Fritze
Subject Re: going gaga on creating an aggregate... [solved of course...]
Date
Msg-id 200004152301.BAA02788@chatsubo.sprawl.de
Whole thread Raw
Responses Re: Re: going gaga on creating an aggregate... [solved of course...]  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Oh my, I've been obfuscating. Again...
While having a couple of beers as mental lubricants in the 
LAP (Local Area Pub), it came to my mind that just doing a 
create aggregate test_agg_1 (basetype = text, stype1 = text, sfunc1 = textcat, initcond1 = '');

and then selecting like
select test_agg_1(textvar || ' ') from testtable;

perfectly suites my needs. Sorry for the fuzz!

Still I'm somewhat curious as to why my first 
approach didn't work...


Greetings
Christian


-- 
"The sky above the port was the color of television,tuned to a dead channel."                                        --
W.G.--
 




pgsql-sql by date:

Previous
From: Christian Fritze
Date:
Subject: going gaga on creating an aggregate...
Next
From: Tom Lane
Date:
Subject: Re: Re: going gaga on creating an aggregate... [solved of course...]