| From: | hubert depesz lubaczewski <depesz(at)gmail(dot)com> |
|---|---|
| To: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: tab_to_sting |
| Date: | 2014-07-23 20:26:30 |
| Message-ID: | CAKrjmhfozt8-ZnAprbwgq9upadaVa69VXxTms0aKCS-STC-ddA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 <rameshparnanditech(at)gmail(dot)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..?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-07-23 20:29:11 | Re: |
| Previous Message | Tom Lane | 2014-07-23 20:16:10 | System shutdown signal on Windows (was Re: [GENERAL]) |