On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote: > Here is the snippet of it.
> TYPE INV_LINES_RT IS RECORD( > VENDOR_NUM A.Datastore.VENDOR_NUM%TYPE, > VENDOR_SITE_CODE A.Datastore.VENDOR_SITE_CODE%TYPE, > INVOICE_NUM A.Datastore.INVOICE_NUM%TYPE, > TXN_CNT NUMBER > ); You can create a composite type in PostgreSQL: CREATE TYPE complex AS (r integer, i integer); > TYPE INV_LINES_T IS TABLE OF INV_LINES_RT; You would use an array in this case: DECLARE carr complex[]; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general