Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EF0454760D7 for ; Mon, 2 Sep 2002 10:44:25 -0400 (EDT) Received: from velan.urbanet.ch (velan.urbanet.ch [195.202.193.140]) by postgresql.org (Postfix) with SMTP id D21AE4760CE for ; Mon, 2 Sep 2002 10:44:24 -0400 (EDT) Received: (qmail 5974 invoked from network); 2 Sep 2002 14:44:34 -0000 Received: from unknown (HELO ASTERIX) (195.202.194.3) by 0 with SMTP; 2 Sep 2002 14:44:34 -0000 Reply-To: From: "Mathias Zajaczkowski" To: Subject: PostgreSQL 7.2 Documentation Date: Mon, 2 Sep 2002 16:43:20 +0200 Message-ID: <71BFB6708920D211967300805F85071C072A73@UBK_SRV1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C2529F.DEB4BE20" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/11 X-Sequence-Number: 1463 C'est un message de format MIME en plusieurs parties. ------=_NextPart_000_0000_01C2529F.DEB4BE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 3.3. Foreign Keys [..] CREATE TABLE cities ( name varchar(80) primary key, location point ); CREATE TABLE weather ( city varchar(80) references weather, temp_lo int, temp_hi int, prcp real, date date ); Table weather refernces table cities and not itself. Best regards Mathias Zajaczkowski, UBIK S.A. Av. Cortot 7d, 1260, Nyon, Switzerland Tel : +41 22 362 04 60 Fax: +41 22 362 04 61 mailto:mathias@ubik.ch http://www.ubik.ch ------=_NextPart_000_0000_01C2529F.DEB4BE20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

3.3. Foreign Keys

[..]

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

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

<=
FONT size=3D3>Table weather refernces table cities and not itse=
lf.

Best regards

Mathias Zajaczkowski,
UBIK S.A.
Av. Cortot 7d,=20
1260, Nyon, Switzerland
Tel : +41 22 362 04 60
Fax:= +41 22 362=20 04 61
mailto:mathias@ubik.ch
http://www.ubik.ch

------=_NextPart_000_0000_01C2529F.DEB4BE20--