Re: [SQL] How to make update statement to work
Andrus Moor [EMAIL PROTECTED] writes: UPDATE demo.toode SET liik=NULL,grupp=NULL WHERE (grupp,liik) NOT IN (SELECT (grupp, liik) FROM artliik) ERROR: operator does not exist: character = record How to write this UPDATE statement
[SQL] How to make update statement to work
I want to nullify fields which does not exist in reference table. I tried UPDATE demo.toode SET liik=NULL,grupp=NULL WHERE (grupp,liik) NOT IN (SELECT (grupp, liik) FROM artliik) but this causes error: ERROR: operator does not