Re: Aggregate function for a text column

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: sathish kumar shanmugavelu <sathishkumar(dot)shanmugavelu(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Aggregate function for a text column
Date: 2006-03-04 05:00:43
Message-ID: 20060304050043.GA55618@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Adam Zimowski 2006-03-05 16:26:36 JDBC support for 8.1 OUT parameters
Previous Message sathish kumar shanmugavelu 2006-03-04 04:45:46 Aggregate function for a text column