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: (view raw or whole 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

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-2015 The PostgreSQL Global Development Group