Re: How to store multiple rows in array .

2017-11-19 18:57 GMT+01:00 Brahmam Eswar <brahmam1234(at)gmail(dot)com>:

> Hi ,
>
> System is migrating from Oracle to Postgre SQL.
> Oracle is providing BULK COLLECT INTO function to collect the multiple
> records from table .
>
> Select COL1,COL2 ,COL3 BULK COLLECT INTO LINES from Distinct_Records.
>
> LINES IS TABLE OF TABLE1 (Defined lines as IS TABLE OF type).
>
> In PotGres:
>
> INV_LINES_T validate_crtr_line_items$inv_lines_rt ARRAY;
> L_INV_LINES INV_LINES_T%TYPE;
> L_INV_LINES$temporary_record ap.validate_crtr_line_items$inv_lines_rt;
>
> I'm trying to collect the records in L_INV_LINES
>
> SELECT ARRAY (SELECT COL1,COL2,COL3 FROM Distinct_Records) INTO
> L_INV_LINES;
>
> Seems, Selecting multiple columns into an array doesn't work in PL/pgSQL
> .
>
> How to collect multiple columns into array which is composite data type of
> all select colums
>

SELECT ARRAY(SELECT ROW(col1, col2, ...) INTO

>
> --
> Thanks & Regards,
> Brahmeswara Rao J.
>