Re: tab_to_sting

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