public inbox for [email protected]  

help / color / mirror / Atom feed

PostgreSQL 7.2 Documentation
2+ messages / 2 participants
[nested] [flat]

* PostgreSQL 7.2 Documentation
@ 2002-09-02 14:43  Mathias Zajaczkowski <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Mathias Zajaczkowski @ 2002-09-02 14:43 UTC (permalink / raw)
  To: 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:[email protected]
http://www.ubik.ch

 


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PostgreSQL 7.2 Documentation
@ 2002-09-03 17:52  Bruce Momjian <[email protected]>
  parent: Mathias Zajaczkowski <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2002-09-03 17:52 UTC (permalink / raw)
  To: [email protected]; +Cc: pgsql-docs


Yes, this is fixed in 7.3, due out in a few months.

---------------------------------------------------------------------------

Mathias Zajaczkowski wrote:
> 
> 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
> 
> ?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-09-03 17:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-02 14:43 PostgreSQL 7.2 Documentation Mathias Zajaczkowski <[email protected]>
2002-09-03 17:52 ` Bruce Momjian <[email protected]>

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