Re: tab_to_sting

[hubert depesz lubaczewski <depesz@xxxxxxxxx>]

I don't know what collect actually does, but just guessing, I would say that you're looking for string_agg()

depesz

On Wed, Jul 23, 2014 at 6:12 PM, Ramesh T <rameshparnanditech@xxxxxxxxx> wrote:

Hi,

        SELECT hr.tab_to_largestring(CAST(COLLECT(cust_name) AS t_varchar2_tab)) AS employees

    FROM   hr.customer

when i run function for  table column values  to single row function name is hr.tab_to_largestring

this code from oracle

  

it return like  function collect(character varying) does not exit

please let me know in postgres collect () key is thier..?

and how to run this function..?