Re: tab_to_sting
| От | Ramesh T |
|---|---|
| Тема | Re: tab_to_sting |
| Дата | |
| Msg-id | CAK8Zd=s+B6E6bjphqbnZ8FWyGQU4VGwdAwHyJ3ZH8gLcr-7W6g@mail.gmail.com обсуждение исходный текст |
| Ответ на | tab_to_sting (Ramesh T <rameshparnanditech@gmail.com>) |
| Список | pgsql-general |
SELECT
qa.tab_to_largestringcheck(cast(array_agg(part_id)as t_varchar2_tab),':')FROM qa.part
when i replace string_agg it's return does not exit,
need to enable string_agg ..?i think is predefined right
On Thu, Jul 24, 2014 at 7:47 PM, Ramesh T <rameshparnanditech@gmail.com> wrote:
postgres 9.3On Thu, Jul 24, 2014 at 7:46 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:On 07/24/2014 07:11 AM, Ramesh T wrote:What version of Postgres are you using?hi ,
i looked into that link ,when i run string_agg does not exist returns
,But i'm using function here not paasing table to the function only i'm
passing column name and delimiter to the function from select statement
please look into the my first post..
The query below should work:
SELECT deptno, string_agg(employee, ',')
FROM emp
GROUP BY deptno;thanks,
ram
--
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: