public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mathias Zajaczkowski <[email protected]>
To: [email protected]
Subject: PostgreSQL 7.2 Documentation
Date: Mon, 2 Sep 2002 16:43:20 +0200
Message-ID: <71BFB6708920D211967300805F85071C072A73@UBK_SRV1> (raw)


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:[email protected]
http://www.ubik.ch

 

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: PostgreSQL 7.2 Documentation
  In-Reply-To: <71BFB6708920D211967300805F85071C072A73@UBK_SRV1>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox