Re: tab_to_sting
| От | Ramesh T |
|---|---|
| Тема | Re: tab_to_sting |
| Дата | |
| Msg-id | CAK8Zd=syzeejnTQ19and7u-k8j07LuQfBjsaes5iGUz6oPHyDQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: tab_to_sting (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: tab_to_sting
|
| Список | pgsql-general |
I have try
select string_agg(partname,':') from part_tab; its return same,
ERROR: function string_agg(bigint, unknown) does not exist
LINE 1: select string_agg(part_id,':') from part;
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
i thought string_agg and array_agg same, is it right..?
On Thu, Jul 24, 2014 at 8:19 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 07/24/2014 07:46 AM, Ramesh T wrote:Please, do not top post.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.
Also try the query I sent you off-list:Forget about the t_varcha2_tab type.
SELECT deptno, string_agg(employee, ',')
FROM emp
GROUP BY deptno;
--
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: