Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 45152476C31 for ; Tue, 26 Feb 2002 14:52:26 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id DDA25D601; Tue, 26 Feb 2002 11:52:22 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id D111A5BFB; Tue, 26 Feb 2002 11:52:22 -0800 (PST) Date: Tue, 26 Feb 2002 11:52:22 -0800 (PST) From: Stephan Szabo To: Christopher Kings-Lynne Cc: David BOURIAUD , Subject: Re: About referential integrity. In-Reply-To: Message-ID: <20020226115027.T93006-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200202/410 X-Sequence-Number: 6832 > > As of PostgreSQL, I don't think it would be a hard thing to put > > on, since the > > relations are stored in a system table, including the fields the > > tables are > > linked by. A sort of syntax : > > > > select * > > from AUTO JOIN t1, t2; > > How is this different from: > > select * > from t1 NATURAL JOIN t2; > > ??? I think he still wants it to work even if the columns aren't named the same. In any case, this isn't likely to be reasonable right now due to the format of that information in the system tables.