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(dot)klaver(at)aklaver(dot)com