Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 26 Nov 2007 13:56:16 +0000
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
- References:
- BUG #3778: Natural join with filter problem
- From: Laurent HERVE
- Re: BUG #3778: Natural join with filter problem
- From: Heikki Linnakangas
- Re: BUG #3778: Natural join with filter problem
- From: Heikki Linnakangas
- Re: BUG #3778: Natural join with filter problem
- From: Laurent HERVE
- BUG #3778: Natural join with filter problem
- Prev by Date: Re: BUG #3778: Natural join with filter problem
- Next by Date: BUG #3779: Setting filesystem permissions error
- Previous by thread: Re: BUG #3778: Natural join with filter problem
- Next by thread: BUG #3779: Setting filesystem permissions error
- Indexes: