Re: Aggregate function for a text column

On Sat, Mar 04, 2006 at 10:15:46AM +0530, sathish kumar shanmugavelu wrote:
> Now i want a result like below
>       'Praveen Systems, Zigma Systems, HCL Tech, Vela Book Shop, Senthil
> Books, Usha,
> Electricals, National Scientific Company, Indian Oil Corporation'

Will something like this work?

SELECT array_to_string(ARRAY(SELECT supplier_name FROM tablename), ', ');

--
Michael Fuhr