array in composite type ?

Selam arkadaslar,

asagidaki oracle dan migrate edilmis iki custom tip var..

oracle
--------------
create or replace
TYPE CLASS_MAPPING_TAB IS TABLE OF class_mapping;

create or replace
TYPE CLASS_MAPPING IS OBJECT (
ID NUMBER,
klasse NUMBER,
text VARCHAR2 (500 CHAR)
);

postgres:
--------------------------
TYPE class_mapping_tab AS
class_mapping_tab class_mapping[];

TYPE CLASS_MAPPING IS OBJECT (
ID NUMBER,
klasse NUMBER,
text VARCHAR2 (500 CHAR)
);

Sizce bu ne kadar dogru bir konvert ?

class_mapping_tab nasil set edebilirim ?

asagidaki gibi olmadi
..
tmpval RECORD;
retval class_mapping_tab;
retval := array[ ROW(tmpval.ID, tmpval.klasse, tmpval.text) ::
class_mapping)];
..

saygilar,
kuecuek