Aggregate function for a text column

From: "sathish kumar shanmugavelu" <sathishkumar(dot)shanmugavelu(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Aggregate function for a text column
Date: 2006-03-04 04:45:46
Message-ID: ee0ad3a30603032045wce1df2ao959a673205cd9f44@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dear Group,
I have a table with a column named Supplier_Name

supplier_name
==========
Praveen Systems
Zigma Systems
HCL Tech
Vela Book Shop
Senthil Books
Usha Electricals
National Scientific Company
Indian Oil Corporation

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'

is it possible in a single query

help me
--
Sathish Kumar.S
SpireTEK

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Fuhr 2006-03-04 05:00:43 Re: Aggregate function for a text column
Previous Message Eberhard Schulte 2006-03-03 09:15:32 Enhancement: toBoolean() and empty String