Postgres Pro
Downloads
Home   >   mailing lists

Re: tab_to_sting - Mailing list pgsql-general

From Ramesh T
Subject Re: tab_to_sting
Date
Msg-id CAK8Zd=s+B6E6bjphqbnZ8FWyGQU4VGwdAwHyJ3ZH8gLcr-7W6g@mail.gmail.com
Whole thread Raw
In response to tab_to_sting  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
Tree view
SELECT 
qa.tab_to_largestringcheck(cast(array_agg(part_id)as t_varchar2_tab),':')FROM qa.part

when i replace string_agg it's return does not exit,

need to enable string_agg ..?i think is predefined right 






On Thu, Jul 24, 2014 at 7:47 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:
postgres 9.3


On Thu, Jul 24, 2014 at 7:46 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 07/24/2014 07:11 AM, Ramesh T wrote:
hi ,
i looked into that link ,when i run string_agg does not exist returns
,But i'm using function here  not paasing table to the function only i'm
passing column name and delimiter to the function from select statement
please look into the my first post..

What version of Postgres are you using?

The query below should work:

SELECT deptno, string_agg(employee, ',')

FROM   emp
GROUP BY deptno;

thanks,
ram


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: tab_to_sting
Next
From: Ramesh T
Date:
Subject: Re: tab_to_sting