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@xxxxxxxxxxx
