i solved my problem using string_agg in tab_to_string
ex:-
select string_agg(s.Rnumber ::text,',' )AS number
On Fri, Feb 13, 2015 at 10:40 PM, Raymond O'Donnell wrote:
> On 13/02/2015 13:13, Ramesh T wrote:
> > cast(COLLECT (r_id) as num) in oracle..
> >
> > is their *collect *function in postg
On 13/02/2015 13:13, Ramesh T wrote:
> cast(COLLECT (r_id) as num) in oracle..
>
> is their *collect *function in postgres plpgsql?or any alternate
> for this..?
I don't use Oracle, but I think array_agg() is the closest - it
aggregates the column into an array.
postgres=# create table test
cast(COLLECT (r_id) as num) in oracle..
is their *collect *function in postgres plpgsql?or any alternate for
this..?
thanks in advance,
2015-02-13 14:13 GMT+01:00 Ramesh T :
> COLLECT
Hi
Depends on what you needs. The collections are not supported by PostgreSQL
- use a arrays instead.
http://www.postgresql.org/docs/9.4/static/arrays.html
Regards
Pavel Stehule
