Re: array in composite type ?

postgres kismini yanlis kopyalamisim:

CREATE TYPE class_mapping AS
(id bigint,
klasse bigint,
text character varying(500)
);

CREATE TYPE class_mapping_tab AS
(class_mapping_tab class_mapping[]);

2016-12-29 11:42 GMT+01:00 Cem Kücük <bcemkucuk(at)gmail(dot)com>:

> 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
>