25 Kasım 2021 Perşembe

CREATE TYPE AS VARARRAY

Örnek
Şöyle yaparız.
create or replace type integer_varray as varray (4000) of int;
create table plan_capacities
(
  id       int generated by default as identity not null
    constraint plan_capacities_pkey primary key,
  line_id  int references lines (id) on delete cascade,
  model_id int references models (id) on delete cascade,
  plan_id  int references plans (id) on delete cascade,
  capacity integer_varray
);

Hiç yorum yok:

Yorum Gönder