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.klaver@aklaver.com