On 07/24/2014 07:46 AM, Ramesh T wrote:
i ran the \df string_agg is theirbut 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 [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
