Contents



企 襷り鍵 るジ DBMS . 覈碁 覓語. 企 一危 磯讌 譴.
CREATE TABLE weather (
	city varchar(80),
	temp_lo int, -- low temperature
	temp_hi int, -- high temperature
	prcp real, -- precipitation
	date date
);

CREATE TABLE cities (
	name varchar(80),
	location point
);

企 drop table 覓語 磯 .
drop table table_name

INSERT INTO weather VALUES (San Francisco, 46, 50, 0.25, 1994-11-27);
INSERT INTO cities VALUES (San Francisco, (-194.0, 53.0));

伎 覲伎 覈詩 point 一危 讌蠍 豌 企 曙 覲伎.. 一危 一危 伎 蟯碁 覓苦 貊る襦 蟲覿 X, Y襯 蟲覿 蟆朱 覲伎碁. 貎朱Μ襯 る慨覃 蟆企 .
select * from cities;

     name      | location
---------------+-----------
 San Francisco | (-194,53)
(1 row)

...覘螳... 覈襯願...讌 Point.x 螳 覃 讌 蟾??
select name, location.x from cities;

Pervasive Demo DB=> select name, location.x from cities;
ERROR:  relation "location" does not exist

<;;
..覃伎殊 覲企る慨覃 り讌...

CREATE TABLE cities (
	city varchar(80) primary key,
	location point
);

CREATE TABLE weather (
	city varchar(80) references cities(city),
	temp_lo int,
	temp_hi int,
	prcp real,
	date date
);

references cities(city) 覿覿 覲企 蟆企. cities 企 city 貉殊 谿語^る
詞企.