| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yuri Sorkin | 2007-11-26 23:45:14 | BUG #3779: Setting filesystem permissions error |
| Previous Message | Laurent HERVE | 2007-11-26 13:47:32 | Re: BUG #3778: Natural join with filter problem |