From: Samuel Gendler <sgendler@ideasculptor.com>
To: Rob Sargent <robjsargent@gmail.com>
Cc: Tripura <k_tripura@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Append n Rows into a Single Row
Date: Sat, 18 Jun 2011 20:51:55 -0700
Message-ID: <BANLkTim1GPLFqiTrXW695Hevvj4Bz8Ch=g@mail.gmail.com> (raw)
In-Reply-To: <4DFD6E22.1090700@gmail.com>
References: <1308356423557-4500306.post@n5.nabble.com>
<4DFD6E22.1090700@gmail.com>
Actually, you need the array_agg() function to aggregate multiple rows into
a single array, and that is discussed on the aggregate functions page,
here: http://www.postgresql.org/docs/9.0/static/functions-aggregate.html
You could then use one of the other array functions to manipulate that
array.
But given that you are appending strings to each other in your example, you
can also just use the string_agg function from that same page - assuming you
are on 9.0. It looks like that function isn't available before 9.0
--sam
On Sat, Jun 18, 2011 at 8:33 PM, Rob Sargent <robjsargent@gmail.com> wrote:
> Look at the array aggregation functions here <http://www.postgresql.org/**
> docs/9.0/static/functions-**array.html<http://www.postgresql.org/docs/9.0/static/functions-array.html;
> >
>
>
> Tripura wrote:
>
>> Hi,
>> I am totally new to PostgreSQL and this is my first script.
>> Can anyone please help me with my following requirement
>> I have script that returns 1 column and 40 rows.
>> My requirement is update this existing script to show all the 40 rows data
>> in a single row as a string.
>>
>> For example The current script returns, something like this Tom
>> Tad
>> Max
>> Ted
>>
>> I have to update the existing script to show the above results as follow
>> Tom || Tad || Max || Ted
>> Something like colace in Ms sql
>>
>> Any help is really appriciated.
>>
>> Thankyou in Advance.
>>
>>
>>
>>
>>
>>
>>
>> --
>> View this message in context: http://postgresql.1045698.n5.**
>> nabble.com/Append-n-Rows-into-**a-Single-Row-**tp4500306p4500306.html<http://postgresql.1045698.n5.nabble.com/Append-n-Rows-into-a-Single-Row-tp4500306p4500306.html;
>> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>>
>>
>>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-sql<http://www.postgresql.org/mailpref/pgsql-sql;
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgendler@ideasculptor.com, robjsargent@gmail.com, k_tripura@hotmail.com
Subject: Re: Append n Rows into a Single Row
In-Reply-To: <BANLkTim1GPLFqiTrXW695Hevvj4Bz8Ch=g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox