I think the way to get the result you want is to suppress the
null-containing rows before they get to the FULL JOIN, like so:
regression=# SELECT *
FROM (SELECT * FROM iandmed WHERE ametikoht IS NOT NULL) AS iandmed
FULL JOIN koosseis ON iandmed.ametikoht=koosseis.ametikoht;
Thank you.
In my case koosseis.ametikoht column does not contain null values.
Si I fixed this in WHERE clause
WHERE (iandmed.ametikoht is not null or koosseis.ametikoht is not null)
I hope this produces same result in my case.
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
