Re: Concatenating multiple fetches into a single string

Dnia 2003-12-02 05:51, Użytkownik Kumar napisał:
> Thanks for your reply.
> 
> But how to use this comma_aggregate( ) function to concatenate the fetched
> columns values from a select statement. In my example my select stmt fetches
> the following 3 rows. How can I use this function to concatenate them.
> 
> Select full_name FROM project_members where project_members.project_role_id
> in ( ' x,y,z ') ;
> 
>  full_name
>  ---------------
>  David
>  Postgres
>  plpgsql
> 
> Expected return string is - 'David,Postgres,Plsql'

Where is the problem?
It's an aggregate function - you use it like the other ones:

select comma(full_name) from...

There is one problem with this function - strings order is unexpectable, 
but you can always sort them in subselect before using this function:

select comma(full_name) from
(select full_name from .... order by full_name) X;

Regards,
Tomasz Myrta