2017-11-19 18:57 GMT+01:00 Brahmam Eswar <brahmam1...@gmail.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. >