> Why not use a LEFT JOIN for this ?
UPDATE firma1.rid SET rid.toode=NULL
LEFT join firma1.toode using(toode)
WHERE rid.toode IS NOT NULL AND toode.toode IS NULL;Causes: ERROR: syntax error at or near "LEFT" at character 41 outer joins are not supported in Postgres UPDATE command. Andrus. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
