Home > mailing lists

[GENERAL] How to store multiple rows in array . - Mailing list pgsql-general

From	Brahmam Eswar
Subject	[GENERAL] How to store multiple rows in array .
Date	November 19, 2017 23:57:00
Msg-id	CA+wLFo2wXFyAmb26Qk8-HTELi0fb4Kr9-k0fAmJFYWh=xbDjZQ@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] How to store multiple rows in array .
List	pgsql-general

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

Thanks & Regards,
Brahmeswara Rao J.

From: Matt Zagrabelny
Date: 18 November 2017, 23:50:10
Subject: Re: [GENERAL] mild modification to pg_dump

From: Pavel Stehule
Date: 19 November 2017, 23:59:47
Subject: Re: [GENERAL] How to store multiple rows in array .