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

[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 d