Skip site navigation (1) Skip section navigation (2)

PostgreSQL 7.2 Documentation

From: "Mathias Zajaczkowski" <mathias(at)ubik(dot)ch>
To: <pgsql-docs(at)postgresql(dot)org>
Subject: PostgreSQL 7.2 Documentation
Date: 2002-09-02 14:43:20
Message-ID: 71BFB6708920D211967300805F85071C072A73@UBK_SRV1 (view raw or flat)
Thread:
Lists: pgsql-docs
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(at)ubik(dot)ch
http://www.ubik.ch

 

Responses

pgsql-docs by date

Next:From: Jerome ChochonDate: 2002-09-03 09:42:50
Subject: PostgreSQL papers
Previous:From: Peter EisentrautDate: 2002-09-01 22:02:11
Subject: Re: Projects moved to gborg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group