Re: How to store multiple rows in array .

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

2017-11-19 18:57 GMT+01:00 Brahmam Eswar <brahmam1234@xxxxxxxxx>:

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.