Re: Turning column into row

On Wed, 22 May 2002, Joel Burton wrote:

> http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=13
> 9 will do as a LIST() replacement.
While beeing a great hint it has a syntactical mistake.

The correct syntax would be:

-- creat function to comma-ify a list

create function comma_aggregate(text,text) returns text as '
begin
if (length($1) > 0 ) then
return $1 || '', '' || $2; /* note the '' here !! */
else
return $2;
end if;
end;
' language 'plpgsql';

A further question: Is there any possibility to add a further flag in the
way:

select fname, lname, comma(hobbies,SPORT_FLAG) from people join hobbies on (personid) group by personid, fname, lname, SPORT_FLAG;

So that we get only those hobbies listed which have SPORT_FLAG = 1
or something else?

Kind regards

Andreas.