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