[GENERAL] How to store multiple rows in array .
От
Brahmam Eswar
Тема
[GENERAL] How to store multiple rows in array .
Дата
Msg-id
CA+wLFo2wXFyAmb26Qk8-HTELi0fb4Kr9-k0fAmJFYWh=xbDjZQ@mail.gmail.com
Список
Дерево обсуждения
[GENERAL] How to store multiple rows in array . Brahmam Eswar <brahmam1234@gmail.com>
Re: [GENERAL] How to store multiple rows in array . Pavel Stehule <pavel.stehule@gmail.com>
Re: [GENERAL] How to store multiple rows in array . Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] How to store multiple rows in array . brahmesr <brahmam1234@gmail.com>
Re: [GENERAL] How to store multiple rows in array . Tom Lane <tgl@sss.pgh.pa.us>
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.
Brahmeswara Rao J.
В списке pgsql-general по дате отправления
