Received: from chatsubo.sprawl.de (root@port-5.ca.kamp.de [195.62.112.197]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA32767 for ; Sat, 15 Apr 2000 19:02:16 -0400 (EDT) (envelope-from finn@chatsubo.sprawl.de) Received: from chatsubo.sprawl.de (finn@localhost [127.0.0.1]) by chatsubo.sprawl.de (8.9.3/8.9.3) with ESMTP id BAA02788; Sun, 16 Apr 2000 01:01:27 +0200 Message-Id: <200004152301.BAA02788@chatsubo.sprawl.de> X-Mailer: exmh version 2.0.2 2/24/98 To: Christian Fritze Cc: "pgsql-sql@postgresql.org" Subject: Re: going gaga on creating an aggregate... [solved of course...] From: Christian Fritze Reply-To: Christian Fritze MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit In-reply-to: Your message of Sat, 15 Apr 2000 21:28:54 +0200. Date: Sun, 16 Apr 2000 01:01:27 +0200 X-Archive-Number: 200004/159 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. --