tab_to_sting

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tab_to_sting
Date: 2014-07-23 16:12:30
Message-ID: CAK8Zd=tzpWPTLaHBJhACo3yCnWDvn_HbLF1dZ8wadZU3tn=ogw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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..?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seamus Abshere 2014-07-23 17:21:11 Why is unique constraint needed for upsert?
Previous Message Igor Neyman 2014-07-23 15:46:09 Re: postgresql_fdw issues with triggers on the foreign tables