Re: tab_to_sting

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(at)gmail(dot)com>
wrote:

> postgres 9.3
>
>
> On Thu, Jul 24, 2014 at 7:46 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 07/24/2014 07:11 AM, Ramesh T wrote:
>>
>>> 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..
>>>
>>
>> What version of Postgres are you using?
>>
>> The query below should work:
>>
>> SELECT deptno, string_agg(employee, ',')
>>
>> FROM emp
>> GROUP BY deptno;
>>
>> thanks,
>>> ram
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>
>