Re: tab_to_sting

On 07/23/2014 09:12 AM, Ramesh T 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..?

To help with getting answers, it would be helpful if you told the list
what the Oracle function does or point to the documentation:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions031.htm#SQLRF51285

Another option would be to investigate EnterpriseDB as they have an
Oracle compatibility layer available:

http://www.enterprisedb.com/


--
Adrian Klaver
adrian.klaver@aklaver.com