Search Postgresql Archives

How to store multiple rows in array .

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux