X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0C985539B9 for ; Sun, 27 Mar 2005 08:57:22 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46423-05 for ; Sun, 27 Mar 2005 07:57:12 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 15F70539DF for ; Sun, 27 Mar 2005 08:57:11 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2R7vAQ6003551; Sun, 27 Mar 2005 02:57:10 -0500 (EST) To: "Andrus Moor" Cc: pgsql-sql@postgresql.org Subject: Re: How to make update statement to work In-reply-to: References: Comments: In-reply-to "Andrus Moor" message dated "Sat, 26 Mar 2005 17:13:19 +0200" Date: Sun, 27 Mar 2005 02:57:10 -0500 Message-ID: <3550.1111910230@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/351 X-Sequence-Number: 20830 "Andrus Moor" 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 properly ? Hmm ... Postgres wants it without the innermost parentheses: (SELECT "grupp", "liik" FROM "artliik") Offhand though I am not certain whether the way you wrote it is supposed to be allowed according to the SQL spec. Does anyone think this should have worked, and if so what's the chapter and verse that says so? regards, tom lane