On Sun, 8 Jun 2003, Tom Lane wrote:
> Eivind Kvedalen <[EMAIL PROTECTED]> writes:
> > SELECT a, concat(b) FROM (SELECT a,b FROM test ORDER BY a,b) T GROUP BY a;
>
> > The ORDER BY is included to sort the rows before they are aggregated. I'm
> > not sure that
Hi
You can create an aggregate function to solve this. A friend of mine asked
the same question a while ago, and I created a possible example solution
for him, which I paste here:
CREATE FUNCTION concat(varchar,varchar) RETURNS varchar
AS 'SELECT CASE
$1 WHEN \'\' THEN $2
