Re: array in composite type ?

Merhabalar,

NUMBER datatype'a karsilik BIGINT yerine NUMERIC kullanmak daha dogru
olacaktir.

VARCHAR yerine TEXT kullanilmasi daha dogru geliyor bana cogunlukla.
Gercekten 500'u gecmesin diye bir sartiniz varsa TEXT kullanin.

Iyi Calismalar,
Eren

On Thu, Dec 29, 2016 at 1:50 PM Cem Kücük <bcemkucuk(at)gmail(dot)com> wrote:

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

--
Thanks,
Good Luck & Have Fun,
Eren