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

Re: BUG #3778: Natural join with filter problem

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Laurent HERVE <laurentjpherve(at)orange(dot)fr>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3778: Natural join with filter problem
Date: 2007-11-26 13:56:16
Message-ID: 474AD080.3050702@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Laurent HERVE wrote:
> ok thank you... and sorry for not having checked enough time in the
> documentation.
> anyway, i think a kind of JOIN ... USING (primary key columns) could be
> useful.
> if you change a primary key, because of design choice, you won't have to
> rewrite all rules and views for example, just simple execute would be
> required. This is why i used NATURAL.

Yeah, I see what you mean. NATURAL JOIN is part of the SQ standard, so 
we're just following that. Matching by foreign keys would make more 
sense to me as well.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: Yuri SorkinDate: 2007-11-26 23:45:14
Subject: BUG #3779: Setting filesystem permissions error
Previous:From: Laurent HERVEDate: 2007-11-26 13:47:32
Subject: Re: BUG #3778: Natural join with filter problem

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