Re: [GENERAL] tab_to_sting

[Adrian Klaver]

On 07/24/2014 07:46 AM, Ramesh T wrote:

i ran the \df string_agg is their

but retuns like
ERROR:  function string_agg(character varying) does not exist
LINE 2: qa.tab_to_largestringcheck(cast(string_agg(part_num)as t_var...
                                         ^
HINT:  No function matches the given name and argument types. You might
need to add explicit type casts.

Please, do not top post.

Also try the query I sent you off-list:

SELECT deptno, string_agg(employee, ',')
FROM   emp
GROUP BY deptno;

Forget about the t_varcha2_tab type.



--
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