Postgres Pro
Downloads
Home   >   mailing lists

Re: tab_to_sting - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: tab_to_sting
Date
Msg-id CAKrjmhfozt8-ZnAprbwgq9upadaVa69VXxTms0aKCS-STC-ddA@mail.gmail.com
Whole thread Raw
In response to tab_to_sting  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> 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..?

pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: tab_to_sting
Next
From: Adrian Klaver
Date:
Subject: Re: