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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
