Postgres Pro
Downloads
Home   >   mailing lists

Aggregate function for a text column - Mailing list pgsql-jdbc

From sathish kumar shanmugavelu
Subject Aggregate function for a text column
Date
Msg-id ee0ad3a30603032045wce1df2ao959a673205cd9f44@mail.gmail.com
Whole thread Raw
Responses Re: Aggregate function for a text column  (Michael Fuhr <mike@fuhr.org>)
List pgsql-jdbc
Tree view
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

pgsql-jdbc by date:

Previous
From: Eberhard Schulte
Date:
Subject: Enhancement: toBoolean() and empty String
Next
From: Michael Fuhr
Date:
Subject: Re: Aggregate function for a text column