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