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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
