Re: [SQL] How to make update statement to work

2005-03-27 Thread Tom Lane
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

2005-03-26 Thread Andrus Moor
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