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 <rameshparnandit...@gmail.com> wrote: > postgres 9.3 > > > On Thu, Jul 24, 2014 at 7:46 PM, Adrian Klaver <adrian.kla...@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.kla...@aklaver.com >> > >
