Please keep the list CC'd.
Laurent HERVE wrote:
in fact, i don't know why the column "code_document" is used because it
is not in the primary key of the tables.
So as this column is nullable, it gives unexpected results.
I thought only the columns on the primary key are taken into account
when building a join. Maybe i misunderstood something in how postgresql
builds the join.
Ah, no. According to the docs:
NATURAL is shorthand for a USING list that mentions all columns in
the two tables that have the same names.
Because there's a column called code_document in both tables, you'll
have to use an INNER JOIN to get what you want. If you want to eliminate
the duplicate columns from the result set like a NATURAL JOIN does, you
can use INNER JOIN ... USING (list of columns).
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
