他鐃塾バ￥申鐃緒申鐃緒申鐃緒申文鐃緒申 鐃緒申 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9.6 | 9.5 | 9.4 | 9.3 | 9.2 | 9.1 | 9.0 | 8.4 | 8.3 | 8.2 | 8.1 | 8.0 | 7.4 | 7.3 | 7.2
PostgreSQL 9.2.4文鐃緒申
鐃緒申鐃塾ペ￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 5鐃熟デ￥申鐃緒申鐃緒申鐃�鐃緒申鐃塾ペ￥申鐃緒申

5.3. 鐃緒申鐃緒申

鐃叔￥申鐃緒申鐃緒申鐃熟￥申鐃銃￥申鐃瞬ワ申乏鐃叔種申鐃緒申鐃叔￥申鐃緒申鐃塾種申鐃緒申鐃緒申鐃所す鐃暑た鐃緒申鐃緒申鐃祝￥申任鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申多鐃緒申鐃塾ワ申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃藷供わ申鐃緒申鐃緒申鐃緒申任鐃緒申鐃縮�鐃緒申鐃祝欠け鐃殉わ申鐃緒申 鐃純え鐃出￥申鐃緒申鐃淑の駕申鐃淑わ申鐃緒申鐃緒申鐃緒申砲蓮鐃緒申鐃緒申鐃緒申蕕�鐃緒申鐃緒申鐃塾みわ申鐃緒申鐃緒申鐃緒申鐃緒申茲�鐃祝わ申鐃緒申必鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾みわ申鐃緒申鐃緒申鐃緒申鐃緒申箸鐃緒申鐃宿醐申鐃塾デ￥申鐃緒申鐃緒申鐃熟わ申鐃緒申泙鐃緒申鐃� 鐃殉わ申鐃緒申他鐃緒申鐃緒申鐃峻に器申連鐃緒申鐃緒申鐃緒申如鐃緒申鐃緒申鐃緒申鐃緒申鵑靴鐃緒申鐃緒申鐃緒申發�鐃緒申泙鐃緒申鐃� 鐃純え鐃出￥申鐃緒申鐃淑の常申鐃緒申鐃緒申鐃獣てわ申鐃緒申董鐃緒申屮鐃叔は￥申1鐃縦わ申鐃緒申鐃緒申鐃瞬刻申砲弔鐃緒申討旅圓鐃�2鐃峻以上あ鐃獣てはなわ申泙鐃緒申鐃�

鐃緒申鐃塾よう鐃緒申鐃緒申鐃緒申鐃緒申茲刻申襪随申瓠�SQL鐃叔わ申鐃藷おわ申咼董鐃緒申屮鐃緒申鐃出わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申砲鐃獣てテ￥申鐃瞬ワ申鐃緒申離如鐃緒申鐃緒申鐃粛鰹申鐃緒申鐃緒申罎刻申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申飽鐃夙随申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃緒申乏鐃叔種申鐃緒申茲�鐃夙わ申鐃緒申函鐃緒申鐃緒申蕁種申箸覆鐃殉わ申鐃緒申 鐃緒申鐃塾わ申鐃夙は￥申鐃叔フワ申鐃緒申鐃緒申佑箸鐃緒申鐃緒申鐃緒申鐃緒申鐃曙た鐃粛わ申鐃叔種申鐃緒申鐃緒申鐃祝わ申適鐃術わ申鐃緒申泙鐃緒申鐃�

5.3.1. 鐃緒申鐃緒申鐃緒申鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申郎任鐃緒申鐃緒申的鐃緒申鐃緒申鐃緒申亮鐃緒申鐃叔わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃術わ申鐃銃￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃粛わ申鐃緒申鐃緒申鐃粛の種申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑随申鐃緒申鐃粛）よう鐃祝誌申鐃緒申任鐃緒申泙鐃緒申鐃� 鐃純え鐃出￥申鐃緒申鐃淑駕申鐃淑わ申必鐃緒申鐃緒申鐃緒申鐃祝わ申鐃緒申砲楼焚鐃緒申里茲�鐃祝わ申鐃殉わ申鐃緒申 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric CHECK (price > 0)
);

鐃緒申鐃塾よう鐃祝￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃熟デフワ申鐃緒申鐃緒申佑鐃緒申鐃緒申鐃緒申同鐃粛に￥申鐃叔￥申鐃緒申鐃緒申鐃塾醐申砲鐃緒申泙鐃緒申鐃� 鐃叔フワ申鐃緒申鐃緒申佑鐃緒申鐃緒申鐃緒申任鐃春の緒申鐃緒申鐃緒申鐃緒申任鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃�CHECK鐃緒申鐃緒申鐃緒ー鐃宿の醐申鐃渋鰹申鐃緒申鐃縮で囲まれた鐃緒申鐃叔刻申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃藷式には￥申鐃緒申鐃藷さわ申鐃緒申鐃緒申泙鐃宿�鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃淑わ申鐃夙￥申鐃緒申鐃緒申呂鐃緒申泙鐃緒申味鐃塾なわ申鐃緒申里砲覆鐃殉わ申鐃緒申

鐃緒申鐃緒申妨鐃緒申未鐃縮常申鐃緒申鐃緒申佞鐃緒申襪鰹申箸鐃叔わ申鐃殉わ申鐃緒申 名鐃緒申鐃緒申鐃春わ申鐃暑こ鐃夙で￥申鐃緒申鐃初ー鐃緒申奪鐃緒申鐃緒申鐃緒申鐃緒申錣�鐃緒申笋刻申鐃緒申覆鐃殉わ申鐃緒申鐃緒申鐃術刻申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鮖仮箸任鐃緒申鐃処う鐃祝なわ申泙鐃緒申鐃� 鐃緒申文鐃熟以駕申鐃緒申鐃縮わ申任鐃緒申鐃� 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric CONSTRAINT positive_price CHECK (price > 0)
);

鐃遵記鐃塾よう鐃祝￥申名鐃緒申鐃春わ申鐃緒申鐃緒申了鐃緒申鐃緒申CONSTRAINT鐃緒申鐃緒申鐃緒ー鐃宿で始め、鐃緒申鐃緒申房鐃緒申婿辧鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申続鐃緒申鐃殉わ申鐃緒申 鐃淑わ申鐃緒申鐃緒申法鐃緒申鐃緒申鐃緒申名鐃緒申鐃緒申蠅件申覆鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃緒申謄鐃祝わ申鐃縮常申鐃緒申鐃緒申佞鐃緒申鐃緒申泙鐃緒申鐃緒申鐃�

鐃緒申鐃緒申鐃緒申鐃緒申任鐃淑ｏ申鐃緒申鐃緒申鐃薯参照わ申鐃暑こ鐃夙わ申任鐃緒申泙鐃緒申鐃� 鐃純え鐃出￥申鐃縮常申鐃緒申覆罰鐃緒申鐃緒申鐃淑わ申鐃叔種申鐃緒申鐃緒申鐃祝￥申必鐃緒申鐃緒申鐃緒申鐃緒申覆鐃緒申名鐃緒申鐃淑わ申鐃緒申鐃純く鐃淑わ申茲�鐃祝わ申鐃緒申鐃緒申鐃夙わ申鐃殉わ申鐃緒申 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric CHECK (price > 0),
    discounted_price numeric CHECK (discounted_price > 0),
    CHECK (price > discounted_price)
);

鐃叔緒申鐃�2鐃縦わ申鐃緒申鐃緒申肋鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃縮わ申任鐃緒申鐃� 3鐃緒申鐃旬わ申鐃緒申鐃緒申任録鐃緒申鐃緒申鐃緒申鐃淑醐申鐃夙ってわ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申娉辰鐃緒申鐃緒申里任呂覆鐃緒申鐃緒申鐃緒申鐃殉で駈申鐃准わ申譴随申鐃所ス鐃緒申鐃緒申鐃緒申霧弔旅鐃緒申椶箸鐃緒申童鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃俊わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申蓮鐃叔わ申佞僚鐃緒申鐃緒申鐃緒申鵑垢襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�

鐃叔緒申鐃�2鐃縦わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃夙醐申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申个鐃緒申鐃�3鐃緒申鐃旬わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃縮個に書かわ申鐃塾で￥申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申噺鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申箸鐃緒申峠颪�わ申鐃夙はでわ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃塾逆はでわ申鐃緒申鐃緒申箸任鐃緒申覆鐃緒申鐃順が鐃緒申鐃緒申泙鐃緒申鐃緒申覆鐃緒申覆鐃緒申鐃緒申鐃緒申鐃熟￥申鐃緒申鐃緒申亡鐃熟�鐃春わ申鐃緒申鐃銃わ申鐃緒申鐃緒申里澆鮖仮箸鐃緒申襪随申鐃叔わ申鐃緒申PostgreSQL鐃熟わ申鐃塾居申則鐃緒申鐃緒申鐃緒申鐃殉わ申鐃藷。わ申鐃緒申鐃緒申他鐃塾デ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃銃ワ申閥鐃縦器申鐃緒申堂鐃銃逸申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申呂鐃緒申竜鐃渋э申暴鐃緒申辰討鐃緒申鐃緒申鐃緒申鐃緒申法鐃� 鐃緒申鐃緒申鐃熟￥申鐃淑駕申鐃塾よう鐃祝書くわ申鐃夙わ申任鐃緒申泙鐃緒申鐃� 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric,
    CHECK (price > 0),
    discounted_price numeric,
    CHECK (discounted_price > 0),
    CHECK (price > discounted_price)
);

鐃緒申鐃暑い鐃熟￥申鐃緒申鐃塾よう鐃祝わ申任鐃緒申泙鐃緒申鐃� 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric CHECK (price > 0),
    discounted_price numeric,
    CHECK (discounted_price > 0 AND price > discounted_price)
);

鐃宿のよう鐃祝わ申鐃暑か鐃熟刻申鐃淳わ申鐃緒申鐃緒申任鐃緒申鐃�

鐃緒申鐃緒申鐃緒申鐃銃縁申佑法鐃緒申董鐃緒申屮鐃緒申鐃緒申鐃緒申名鐃緒申鐃緒申鐃緒申鐃緒申鐃銃るこ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric,
    CHECK (price > 0),
    discounted_price numeric,
    CHECK (discounted_price > 0),
    CONSTRAINT valid_discount CHECK (price > discounted_price)
);

鐃緒申鐃緒申鐃緒申鐃緒申任蓮鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�NULL鐃粛わ申評鐃緒申鐃緒申鐃曙た鐃緒申鐃祝￥申鐃緒申錣�鐃緒申鐃緒申鐃緒申鐃緒申襪鰹申箸鐃緒申鐃緒申佞鐃緒申堂鐃緒申鐃緒申鐃緒申鐃� 鐃循とわ申匹亮鐃緒申蓮鐃緒申藥誌申鐃緒申椶飽鐃縦でわ申NULL鐃緒申鐃緒申鐃緒申鐃�NULL鐃緒申評鐃緒申鐃緒申鐃緒申鐃塾で￥申鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃緒申鐃緒申仂櫃鐃緒申鐃緒申NULL鐃粛わ申鐃緒申鐃緒申里鐃緒申匹鐃緒申泙鐃緒申鐃� 鐃緒申NULL鐃粛わ申泙泙覆鐃緒申茲�鐃祝わ申鐃暑た鐃緒申法鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申NULL鐃緒申鐃緒申鐃緒申鐃術わ申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申

5.3.2. 鐃緒申NULL鐃緒申鐃緒申

鐃緒申NULL鐃緒申鐃緒申鐃獣縁申鐃祝￥申鐃緒申NULL鐃粛わ申鐃緒申覆鐃緒申鐃緒申箸鐃緒申鐃所し鐃殉わ申鐃緒申 鐃緒申文鐃緒申鐃緒申楼焚鐃緒申鐃緒申未鐃叔わ申鐃緒申 

CREATE TABLE products (
    product_no integer NOT NULL,
    name text NOT NULL,
    price numeric
);

鐃緒申NULL鐃緒申鐃緒申肋鐃緒申鐃緒申鐃緒申鐃緒申箸鐃緒申撞鐃緒申劼鐃緒申鐃殉わ申鐃緒申 鐃緒申NULL鐃緒申鐃緒申鐃�CHECK (column_name IS NOT NULL)鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申筏鐃叔重�鐃祝わ申同鐃緒申鐃叔わ申鐃緒申鐃緒申PostgreSQL鐃叔は￥申鐃緒申鐃緒申的鐃緒申鐃緒申NULL鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申的鐃叔わ申鐃緒申 鐃緒申鐃塾よう鐃祝削申鐃緒申鐃緒申鐃曙た鐃緒申NULL鐃緒申鐃緒申鐃緒申鐃緒申鐃重�鐃緒申名鐃緒申鐃緒申鐃春わ申鐃緒申鐃淑わ申鐃塾わ申鐃緒申鐃緒申鐃叔わ申鐃緒申

鐃緒申鐃緒申鐃緒申鐃�1鐃縦わ申鐃緒申鐃淑ｏ申鐃緒申鐃緒申鐃緒申鐃緒申適鐃術わ申鐃暑こ鐃夙わ申任鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾わ申鐃緒申砲蓮鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申颪い討鐃緒申鐃緒申鐃緒申鐃緒申任鐃緒申鐃� 

CREATE TABLE products (
    product_no integer NOT NULL,
    name text NOT NULL,
    price numeric NOT NULL CHECK (price > 0)
);

鐃緒申鐃緒申牢愀鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃書かれた鐃緒申鐃緒申噺鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申必鐃緒申鐃緒申鐃緒申同鐃緒申鐃叔はわ申鐃緒申泙鐃緒申鐃�

NOT NULL鐃緒申鐃緒申鐃緒申个鐃緒申鐃緒申佞離僖鐃緒申鐃緒申鐃叔わ申鐃緒申NULL鐃緒申鐃藷がわ申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申蓮鐃緒申鐃�NULL鐃叔なわ申鐃緒申个覆鐃淑わ申鐃夙わ申鐃緒申鐃緒申鐃夙ではわ申鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾よう鐃緒申鐃緒申鐃緒申楼鐃縮ｏ申鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃�NULL鐃叔わ申鐃獣てわ申茲わ申箸鐃緒申鐃緒申妊侫鐃緒申鐃夙の随申鐃書いわ申鐃緒申鐃薯すわ申鐃緒申鐃緒申里鐃塾でわ申鐃緒申 NULL鐃緒申鐃緒申鐃宿醐申鐃�SQL鐃祝わ申存鐃淳わ申鐃殉わ申鐃緒申里如鐃緒申椰鐃粛緒申鐃塾ワ申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃叔は誌申鐃術わ申鐃駿わ申鐃叔はわ申鐃緒申泙鐃緒申鐃� 鐃淑わ申鐃緒申蓮鐃�PostgreSQL鐃緒申他鐃塾逸申鐃緒申鐃塾デ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃銃ワ申箸慮澳鐃緒申鐃緒申里鐃緒申鐃緒申鐃宿加わ申鐃曙た鐃緒申能鐃祝過ぎ鐃殉わ申鐃藷。￥申 鐃緒申辰箸癲�鐃緒申鐃緒申鐃緒申廛肇侫鐃緒申鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申擇鐃緒申悗鐃緒申鐃緒申鐃獣縁申任鐃緒申鐃夙わ申鐃緒申鐃緒申由鐃叔わ申鐃塾居申能鐃薯歓迎わ申鐃緒申罅種申鐃緒申發わ申泙鐃緒申鐃� 鐃純え鐃出￥申鐃叔緒申鐃� 

CREATE TABLE products (
    product_no integer NULL,
    name text NULL,
    price numeric NULL
);

鐃夙書いてわ申鐃初、必鐃竣な常申鐃緒申NOT鐃緒申鐃緒申鐃緒ー鐃宿わ申鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申

鐃銃ワ申鐃獣ワ申: 鐃循とわ申匹離如鐃緒申鐃緒申戞鐃緒申鐃緒申澤廚砲鐃緒申鐃緒申董鐃緒申鐃緒申鐃緒申多鐃緒申鐃緒申NOT NULL鐃夙マ￥申鐃緒申鐃緒申鐃緒申必鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃�

5.3.3. 鐃緒申鐃緒申鐃緒申鐃緒申鐃�

鐃緒申鐃緒申鐃緒申鐃緒申鐃祝わ申辰董鐃緒申鵑△襪わ申鐃緒申鐃塾ワ申鐃暑ー鐃竣に含まわ申鐃叔￥申鐃緒申鐃緒申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申討旅圓念鐃春でわ申鐃暑こ鐃夙わ申亮造砲鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申両鐃緒申旅鐃淑醐申楼焚鐃緒申鐃緒申未鐃叔わ申鐃緒申 

CREATE TABLE products (
    product_no integer UNIQUE,
    name text,
    price numeric
);

鐃殉わ申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申両鐃緒申旅鐃淑醐申鐃� 

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric,
    UNIQUE (product_no)
);

鐃夙なわ申泙鐃緒申鐃�

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾ワ申鐃暑ー鐃竣を参照わ申鐃緒申鐃順、鐃緒申鐃緒申魯鐃緒申鐃殉で駈申鐃准っわ申鐃緒申鵑靴泙鐃緒申鐃� 

CREATE TABLE example (
    a integer,
    b integer,
    c integer,
    UNIQUE (a, c)
);

鐃緒申鐃緒申蓮鐃緒申鐃緒申蠅居申譴随申鐃緒申鐃粛わ申鐃夙み刻申錣誌申鐃緒申董鐃緒申屮鐃緒申鐃緒申里念鐃春でわ申鐃暑こ鐃夙わ申鐃緒申蠅件申討鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃春でわ申鐃緒申必鐃竣はわ申鐃緒申泙鐃緒申鐃緒申鐃縮常申鐃春ではわ申鐃緒申泙鐃緒申鐃祝￥申

鐃緒申鐃緒申鐃緒申鐃緒申鐃祝は￥申鐃緒申鐃縦わ申里茲�鐃緒申名鐃緒申鐃緒申鐃緒申鐃緒申鐃銃るこ鐃夙わ申任鐃緒申泙鐃緒申鐃� 

CREATE TABLE products (
    product_no integer CONSTRAINT must_be_different UNIQUE,
    name text,
    price numeric
);

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃宿加わ申鐃緒申函鐃緒申鐃緒申鐃叔使わ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃塾ワ申鐃暑ー鐃竣わ申鐃出わ申鐃銃逸申鐃重�鐃緒申btree鐃緒申鐃緒申妊奪鐃緒申鐃緒申鐃緒申鐃銃暗�鐃祝削申鐃緒申泙鐃緒申鐃�

鐃緒申鐃縮に￥申鐃緒申鐃緒申鐃緒申仂櫃箸覆鐃緒申鐃祝つわ申鐃緒申同鐃緒申鐃粛わ申鐃緒申長圓鐃緒申鐃緒申董鐃緒申屮鐃緒申鐃祝ｏ申鐃峻わ申鐃緒申鐃緒申鐃熟￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申反鐃祝なわ申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申咾任鐃�2鐃縦わ申NULL鐃粛わ申鐃緒申鐃緒申鐃夙はみなわ申鐃緒申泙鐃緒申鐃� 鐃縦まり、鐃緒申鐃緒申鐃緒申鐃緒申鵑�わ申鐃獣わ申鐃夙わ申鐃銃も、鐃緒申鐃緒申鐃出象わ申鐃緒申両鐃緒申覆鐃緒申箸鐃�1鐃縦わ申NULL鐃粛わ申鐃緒申長圓鐃淑ｏ申鐃緒申鐃叔種申鐃緒申襪鰹申箸鐃緒申任鐃緒申鐃夙わ申鐃緒申鐃緒申鐃夙でわ申鐃緒申 鐃緒申鐃塾随申鐃書いわ申標鐃緒申SQL鐃祝緒申鬚靴討鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申竜鐃渋э申暴鐃緒申鐃淑わ申SQL鐃叔￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙わ申聞鐃緒申鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申泙鐃緒申鐃� 鐃叔わ申鐃緒申鐃初、鐃旬随申鐃緒申鐃緒申予鐃緒申離鐃緒申廛螢縁申鐃緒申鐃緒申鐃緒申鐃夙�鐃緒申鐃緒申櫃砲鐃緒申鐃緒申佞鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃�

5.3.4. 鐃竣ライ鐃殉リキ鐃緒申

鐃緒申鐃緒申的鐃祝は￥申鐃竣ライ鐃殉リキ鐃緒申鐃緒申鐃緒申鐃獣縁申鐃祝逸申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申NULL鐃緒申鐃緒申鐃緒申箸濆鐃緒せ鐃緒申鐃緒申里任鐃緒申鐃� 鐃縦まり、鐃緒申鐃緒申2鐃縦のテ￥申鐃瞬ワ申鐃緒申鐃緒申鐃銃縁申鐃緒申如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 

CREATE TABLE products (
    product_no integer UNIQUE NOT NULL,
    name text,
    price numeric
);

CREATE TABLE products (
    product_no integer PRIMARY KEY,
    name text,
    price numeric
);

鐃竣ライ鐃殉リキ鐃緒申鐃叔わ申複鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鵑垢襪鰹申箸鐃緒申任鐃緒申鐃緒申鐃緒申旅鐃淑醐申楼鐃緒申鐃緒申鐃緒申鐃緒申忙鐃緒申討鐃緒申泙鐃緒申鐃� 

CREATE TABLE example (
    a integer,
    b integer,
    c integer,
    PRIMARY KEY (a, c)
);

鐃竣ライ鐃殉リキ鐃緒申鐃熟￥申鐃緒申泙鐃緒申鐃緒申鐃塾ワ申鐃暑ー鐃竣を、テ￥申鐃瞬ワ申鐃緒申嚢圓琉鐃春の種申鐃縮子とわ申鐃銃誌申鐃術でわ申鐃暑こ鐃夙を示わ申鐃殉わ申 鐃淑わ申鐃塾わ申鐃夙は￥申鐃竣ライ鐃殉リキ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申直鐃旬の居申鐃緒申任鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃叔わ申NULL鐃粛わ申鐃緒申鐃緒申鐃緒申覆鐃緒申鐃緒申瓠�鐃緒申佞亮鐃緒申婿劼鐃緒申鷆，鐃緒申鐃淑わ申鐃緒申鐃夙わ申鐃緒申鐃春わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 鐃緒申鐃緒申鐃淑醐申餡宗鐃緒申鐃緒申鐃俊￥申鐃緒申鐃初イ鐃緒申鐃緒申肇鐃緒申廛螢縁申鐃緒申鐃緒申鐃緒申鐃塾常申鐃緒申鐃緒申未鐃緒申鐃緒申立鐃緒申鐃殉わ申鐃緒申 鐃純え鐃出￥申鐃緒申鐃粛わ申鐃術刻申鐃緒申鐃緒申能鐃緒申GUI鐃緒申鐃竣リケ鐃緒申鐃緒申鐃緒申鵑�行わ申鐃緒申的鐃緒申鐃緒申鐃所す鐃暑た鐃緒申砲蓮鐃緒申鐃緒申鐃緒申蕕�鐃銃￥申鐃瞬ワ申離廛薀わ申泪螢�鐃緒申鐃緒申鐃塾わ申必鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃�

鐃竣ライ鐃殉リキ鐃緒申鐃緒申鐃宿加わ申鐃緒申函鐃緒申廛薀わ申泪螢�鐃緒申鐃叔使わ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃塾ワ申鐃暑ー鐃竣わ申鐃出わ申鐃銃逸申鐃重�鐃緒申btree鐃緒申鐃緒申妊奪鐃緒申鐃緒申鐃緒申鐃銃暗�鐃祝削申鐃緒申泙鐃緒申鐃�

1鐃縦のテ￥申鐃瞬ワ申郎鐃緒申鐃�1鐃縦のプライ鐃殉リキ鐃緒申鐃緒申鐃緒申弔鐃緒申箸鐃緒申任鐃緒申泙鐃緒申鐃� 鐃淑逸申鐃緒申鐃緒申鐃緒申鵑�わ申鐃緒申鐃�NULL鐃緒申鐃緒申砲聾朕鐃緒申鐃緒申鐃緒申造呂鐃緒申鐃殉わ申鐃緒申 鐃緒申能的鐃祝わ申同鐃緒申鐃緒申里任鐃緒申鐃緒申鐃緒申廛薀わ申泪螢�鐃緒申鐃夙わ申鐃銃種申鐃縮わ申鐃緒申鐃緒申鐃緒申鐃緒申1鐃縦のみでわ申鐃緒申鐃緒申 鐃緒申譟種申鐃緒申鐃淑ワ申如鐃緒申鐃緒申戞鐃緒申鐃緒申鐃緒申鐃緒申任蓮鐃緒申鐃緒申討離董鐃緒申屮鐃祝プライ鐃殉リキ鐃緒申鐃緒申1鐃緒申必鐃竣とわ申鐃緒申討鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾居申則鐃緒申PostgreSQL鐃叔は駈申鐃緒申鐃緒申鐃緒申泙鐃緒申鵑�￥申鐃緒申鐃緒申鐃銃わ申鐃塾常申鐃熟わ申鐃緒申暴鐃緒申鐃緒申鐃緒申箸鐃緒申箴�鐃緒申鐃緒申泙鐃緒申鐃�

5.3.5. 鐃緒申鐃緒申鐃緒申鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃淑まわ申鐃緒申鐃緒申離鐃緒申襦種申廖砲鐃緒申佑鐃緒申鐃渋常申離董鐃緒申屮鐃塾行わ申鐃粛と逸申鐃竣わ申鐃淑わ申鐃緒申个覆鐃淑わ申鐃緒申鐃夙わ申鐃緒申蠅件申泙鐃緒申鐃� 鐃緒申鐃緒申砲鐃獣て器申連鐃緒申鐃緒申2鐃縦のテ￥申鐃瞬ワ申鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃楯誌申鐃緒申鐃緒申泙鐃緒申鐃�

鐃緒申鐃緒申任泙撚鐃緒申戮鐃緒申鐃祝誌申鐃術わ申鐃緒申products鐃銃￥申鐃瞬ワ申砲弔鐃緒申胴佑鐃緒申討澆泙鐃緒申鐃� 

CREATE TABLE products (
    product_no integer PRIMARY KEY,
    name text,
    price numeric
);

鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑わ申鐃出わ申鐃緒申鐃緒申文鐃緒申鐃叔種申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃術みわ申鐃夙わ申鐃殉わ申鐃順う鐃緒申 鐃緒申鐃緒申鐃緒申文鐃緒申orders鐃銃￥申鐃瞬ワ申砲麓尊櫃鐃渋醐申澆鐃緒申鐃緒申鐃緒申覆鐃緒申鐃淑醐申里澆鐃緒申納鐃緒申鐃緒申鐃緒申鐃夙思ってわ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃叔￥申products鐃銃￥申鐃瞬ワ申鮖仮箸鐃緒申鐃�orders鐃銃￥申鐃瞬ワ申乏鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 

CREATE TABLE orders (
    order_id integer PRIMARY KEY,
    product_no integer REFERENCES products (product_no),
    quantity integer
);

鐃緒申鐃緒申如鐃�products鐃銃￥申鐃瞬ワ申鐃渋醐申澆鐃緒申覆鐃緒申鐃�NULL鐃緒申product_no鐃緒申鐃旬わ申鐃緒申僂鐃緒申鐃緒申鐃淑醐申鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙はでわ申鐃淑わ申鐃淑わ申泙鐃緒申鐃�

鐃緒申鐃塾よう鐃淑常申鐃祝￥申orders鐃銃￥申鐃瞬ワ申里鐃緒申箸鐃�鐃緒申鐃緒申鐃銃￥申鐃瞬ル、product鐃銃￥申鐃瞬ワ申里鐃緒申箸鐃�鐃緒参鐃緒申鐃銃￥申鐃瞬ワ申噺討咾泙鐃緒申鐃� 同鐃粛に￥申鐃緒申鐃緒申鐃緒申鐃緒申鏤駕申鐃緒申鐃盾あ鐃緒申泙鐃緒申鐃�

鐃遵記鐃塾ワ申鐃殉ワ申匹蓮鐃緒申鐃緒申里茲�鐃緒申短鐃縮わ申鐃暑こ鐃夙わ申任鐃緒申泙鐃緒申鐃� 

CREATE TABLE orders (
    order_id integer PRIMARY KEY,
    product_no integer REFERENCES products,
    quantity integer
);

鐃緒申螢刻申箸鐃緒申覆鐃緒申鐃緒申瓠�鐃緒参鐃夙テ￥申鐃瞬ワ申離廛薀わ申泪螢�鐃緒申鐃緒申鐃緒参鐃緒申鐃緒申鐃淑ｏ申鐃緒申帖砲箸鐃緒申道鐃緒申僂鐃緒申鐃殉わ申鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申鐃叔も、鐃緒申離鐃緒申襦種申廚鐃緒申鐃緒申鵑靴鐃緒申蟷駕申箸鐃緒申鐃緒申蠅刻申襪鰹申箸鐃叔わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃殉わ申鐃緒申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申侶鐃緒申鐃緒申乃鐃緒申劼鐃緒申鐃宿�鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃� 鐃淑駕申鐃熟￥申鐃緒申鐃緒申鐃塾わ申鐃緒申鐃緒申鷂充鐃重�鐃緒申鐃緒申任鐃緒申鐃� 

CREATE TABLE t1 (
  a integer PRIMARY KEY,
  b integer,
  c integer,
  FOREIGN KEY (b, c) REFERENCES other_table (c1, c2)
);

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鵑気鐃緒申鐃緒申鐃緒申鐃緒申鐃俊件申鐃熟￥申鐃緒参鐃緒申鐃緒申凌鐃緒申鐃緒申鐃俊件申鐃夙逸申鐃竣わ申鐃淑わ申鐃緒申个覆鐃殉わ申鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申鐃祝は￥申鐃淑駕申鐃塾よう鐃祝わ申鐃緒申名鐃緒申鐃緒申鐃緒申鐃緒申鐃銃るこ鐃夙わ申任鐃緒申泙鐃緒申鐃�

鐃銃￥申鐃瞬ワ申砲鐃淑ｏ申鐃緒申粒鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃緒申鐃塾わ申鐃夙はテ￥申鐃瞬ワ申屬鐃渋随申鐃渋随申愀鐃緒申鐃緒申鐃緒申鐃緒申鐃暑た鐃緒申忙鐃緒申僂鐃緒申鐃殉わ申鐃緒申 鐃純え鐃出￥申鐃緒申鐃淑わ申鐃緒申文鐃祝関わ申鐃暑そ鐃曙ぞ鐃緒申離董鐃緒申屮襪�鐃緒申鐃緒申鐃緒申法鐃淑ｏ申鐃緒申鐃緒申鐃緒申覆砲泙鐃緒申鐃緒申鐃緒申鐃淑醐申鐃緒申能鐃祝わ申鐃緒申鐃緒申鐃夙わ申鐃殉わ申 鐃淑常申鐃緒申鐃塾刻申造鐃叔わ申鐃峻駕申能鐃叔わ申鐃祝￥申 鐃緒申鐃塾常申隋�鐃緒申鐃塾テ￥申鐃瞬ル構造鐃緒申鐃緒申僂任鐃緒申泙鐃緒申鐃� 

CREATE TABLE products (
    product_no integer PRIMARY KEY,
    name text,
    price numeric
);

CREATE TABLE orders (
    order_id integer PRIMARY KEY,
    shipping_address text,
    ...
);

CREATE TABLE order_items (
    product_no integer REFERENCES products,
    order_id integer REFERENCES orders,
    quantity integer,
    PRIMARY KEY (product_no, order_id)
);

鐃叔醐申離董鐃緒申屮鐃叔￥申鐃竣ライ鐃殉リキ鐃緒申鐃夙鰹申鐃緒申鐃緒申鐃緒申鐃緒申鐃重なってわ申鐃暑こ鐃夙わ申鐃緒申鐃旬わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑に器申連鐃春わ申鐃緒申鐃銃わ申鐃淑わ申鐃緒申文鐃塾削申鐃緒申鐃緒申鐃緒申弔鐃緒申覆鐃緒申鐃緒申箸蓮鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申未鐃叔わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申文鐃叔誌申鐃夙わ申鐃銃わ申鐃緒申鐃緒申鐃淑わ申鐃緒申鐃緒申文鐃緒申忘鐃緒申鐃緒申鐃曙た鐃緒申匹鐃緒申覆鐃叔わ申鐃順う鐃緒申 SQL鐃叔はわ申鐃塾よう鐃淑常申鐃盾扱鐃緒申鐃緒申鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 直鐃緒申的鐃祝￥申鐃緒申鐃緒申鐃縦わ申鐃塾ワ申鐃竣ワ申鐃緒申鵑�考わ申鐃緒申鐃殉わ申鐃緒申

鐃緒申鐃緒申鐃緒申箸鐃緒申董鐃緒申鐃緒申鐃緒申鐃渋随申鐃渋随申愀鐃緒申房鐃緒申離櫂螢件申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃みまわ申鐃順う鐃緒申 鐃緒申order_items鐃祝わ申辰董鐃緒申鐃淑醐申濃鐃緒申箸鐃緒申譴随申泙泙鐃緒申鐃緒申覆鐃緒申鐃緒申鐃緒申茲�鐃緒申鐃銃も、鐃緒申鐃緒申鐃緒申鐃緒申圓鐃緒申覆鐃緒申茲�鐃祝わ申鐃殉わ申鐃緒申 鐃緒申文鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申函鐃緒申鐃淑醐申鐃緒申椶鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 

CREATE TABLE products (
    product_no integer PRIMARY KEY,
    name text,
    price numeric
);

CREATE TABLE orders (
    order_id integer PRIMARY KEY,
    shipping_address text,
    ...
);

CREATE TABLE order_items (
    product_no integer REFERENCES products ON DELETE RESTRICT,
    order_id integer REFERENCES orders ON DELETE CASCADE,
    quantity integer,
    PRIMARY KEY (product_no, order_id)
);

鐃緒申鐃緒申鐃緒申鐃緒申造鐃緒申鐃俊ワ申鐃緒申鐃緒申鐃緒申鐃宿とわ申鐃緒申2鐃縦は￥申鐃叔わ申鐃緒申鐃重�鐃淑ワ申鐃竣ワ申鐃緒申鐃叔わ申鐃緒申 RESTRICT鐃熟￥申鐃緒参鐃夙行わ申鐃緒申鐃緒申鐃緒申鐃緒申里鐃緒申匹鐃緒申泙鐃緒申鐃� NO ACTION鐃熟￥申鐃緒申鐃藷が醐申鐃緒申鐃緒申鐃曙た鐃緒申鐃祝誌申鐃夙行わ申鐃殉わ申存鐃淳わ申鐃銃わ申鐃緒申鐃緒申鐃祝￥申鐃緒申鐃初ー鐃夙なるこ鐃夙わ申鐃縮ｏ申鐃緒申討鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃緒申鐃所し鐃淑わ申鐃緒申鐃塾デフワ申鐃緒申箸凌鐃緒申颪い箸覆鐃殉わ申 鐃淑わ申鐃緒申鐃緒申鐃緒申鐃緒申琉磴わ申蓮鐃�NO ACTION鐃叔は醐申鐃緒申鐃緒申肇鐃藷ザワ申鐃緒申鐃緒申鐃緒申鐃叔醐申鵑靴砲鐃緒申襪鰹申箸鐃緒申任鐃緒申鐃塾わ申鐃出わ申鐃緒申RESTRICT鐃叔は醐申鵑靴砲任鐃緒申覆鐃緒申箸鐃緒申鐃緒申鐃緒申箸任鐃緒申法鐃� CASCADE鐃緒申鐃緒参鐃夙行わ申鐃緒申鐃緒申鐃緒申譴随申鐃緒申鐃緒申鐃緒申鐃薯参照わ申鐃緒申圈鐃淑ｏ申鐃緒申帖砲鐃銃縁申佑忘鐃緒申鐃緒申鐃緒申覆鐃緒申鐃出なわ申覆鐃緒申鐃緒申箸鐃緒申鐃所し鐃殉わ申鐃緒申 他鐃祝わ申2鐃縦のワ申鐃竣ワ申鐃緒申鵑�わ申鐃緒申泙鐃緒申鐃� SET NULL鐃緒申SET DEFAULT鐃叔わ申鐃緒申 鐃緒申鐃緒申鐃熟￥申鐃緒参鐃夙行わ申鐃緒申鐃緒申鐃緒申譴随申櫃法鐃緒申鐃緒申鐃緒申鵑�わ申鐃曙ぞ鐃緒申NULL鐃緒申鐃叔フワ申鐃緒申箸鐃緒申鐃緒申蠅居申鐃緒申茲�鐃祝なわ申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申襪鰹申箸鐃緒申判鐃緒申鐃緒申襪鰹申箸任呂覆鐃緒申鐃緒申箸鐃緒申鐃緒申鐃緒申箸鐃緒申鐃緒申佞鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃� 鐃純え鐃出￥申動鐃緒申鐃�SET DEFAULT鐃緒申鐃緒申蠅件申鐃緒申箸鐃緒申討癲�鐃叔フワ申鐃緒申鐃緒申佑鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑わ申鐃緒申鐃祝わ申鐃緒申鐃熟種申鐃峻わ申鐃殉わ申鐃緒申

ON DELETE鐃祝誌申鐃緒申鐃緒申里如鐃緒申鏤駕申鐃緒申鐃緒申儿鐃緒申聞鐃緒申鐃緒申砲鐃緒申譴随申鐃緒申妨討喀个鐃緒申鐃緒申ON UPDATE鐃盾あ鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申蕕�鐃峻わ申鐃暑ア鐃緒申鐃緒申鐃緒申鐃緒申同鐃緒申鐃叔わ申鐃緒申

鐃緒参鐃夙テ￥申鐃瞬ルか鐃緒申旅圓鐃�DELETE鐃緒申鐃緒参鐃夙行わ申UPDATE鐃熟￥申鐃重わ申鐃粛と逸申鐃竣わ申鐃緒申圓鐃緒申个鐃緒申道鐃緒申肇董鐃緒申屮鐃塾ワ申鐃緒申鐃緒申鐃緒申鐃竣求し鐃殉わ申鐃塾で￥申鐃緒申鐃夙行にワ申鐃緒申妊奪鐃緒申鐃緒申鐃緒申佞鐃緒申鐃塾わ申鐃緒申鐃緒申鐃緒申匹鐃緒申佑鐃緒申任鐃緒申鐃� 鐃緒申鐃緒申肋鐃緒申必鐃竣とわ申鐃緒申鐃緒申鐃叔はなわ申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申妊奪鐃緒申鐃緒申鐃緒申鐃祝￥申砲鐃渋随申鐃緒申鐃緒申鐃緒申鐃処が鐃緒申鐃緒申泙鐃緒申里如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任六鐃緒申鐃緒申鐃塾ワ申鐃緒申妊奪鐃緒申鐃緒申鐃緒申鐃銃暗�鐃祝削申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃夙はわ申鐃緒申泙鐃緒申鐃�

鐃叔￥申鐃緒申鐃塾刻申鐃緒申鐃緒申鐃緒申唳鐃緒申鐃祝つわ申鐃銃詳わ申鐃緒申鐃熟￥申鐃緒申6鐃緒申鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申

鐃叔醐申法鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申魯廛薀わ申泪螢�鐃緒申鐃殉わ申鐃熟逸申鐃緒申鐃緒申鐃緒申鐃塾わ申鐃緒申鐃曙か鐃叔わ申鐃緒申鐃緒申鮖仮箸鐃緒申討鐃緒申鐃宿�鐃竣わ申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃薯参照わ申鐃銃わ申鐃緒申鐃順、NULL鐃粛わ申匹里茲�鐃緒申鐃出縁申鐃緒申鐃緒申鐃暑か鐃祝関わ申鐃緒申他鐃緒申鐃緒申法鐃緒申鐃緒申鐃緒申鐃縦わ申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃祝つわ申鐃銃は￥申鐃緒申侫鐃緒申鐃緒申文鐃緒申鐃�CREATE TABLE鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�

5.3.6. 鐃緒申他鐃緒申鐃緒申

鐃緒申他鐃緒申鐃緒申砲鐃獣て￥申2鐃縦の行に関わ申鐃銃誌申鐃所さ鐃曙た鐃緒申發件申鐃緒申麓鐃緒申鐃緒申鐃所さ鐃曙た鐃初算鐃述わ申鐃緒申鐃術わ申鐃緒申鐃緒申咾鐃緒申鐃緒申鐃緒申法鐃緒申鐃緒申覆鐃緒申箸鐃初算鐃述わ申鐃緒申咾鐃�1鐃縦わ申鐃緒申鐃盾し鐃緒申鐃緒申null鐃緒申鐃瞬わ申鐃緒申鐃夙わ申亮造砲鐃緒申泙鐃緒申鐃� 鐃緒申文鐃熟以駕申鐃緒申鐃縮わ申任鐃緒申鐃� 

CREATE TABLE circles (
    c circle,
    EXCLUDE USING gist (c WITH &&)
);

鐃旬細わ申CREATE TABLE ... CONSTRAINT ... EXCLUDE鐃薯参照わ申鐃銃駕申鐃緒申鐃緒申鐃緒申

鐃緒申他鐃緒申鐃緒申鐃緒申媛辰鐃緒申鐃夙￥申鐃緒申鐃緒申鐃緒申鐃緒申濃鐃緒申蠅居申譴随申鐃緒申鐃塾ワ申鐃緒申妊奪鐃緒申鐃緒申鐃緒申鐃銃暗�鐃祝削申鐃緒申泙鐃緒申鐃�

鐃緒申鐃塾ペ￥申鐃緒申鐃循￥申鐃緒申鐃緒申鐃塾ペ￥申鐃緒申
鐃叔フワ申鐃緒申鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃ワ申鐃緒申