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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
