Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E6F669FC045 for ; Thu, 17 May 2007 14:20:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 06896-07 for ; Thu, 17 May 2007 14:20:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id CFE4B9FC052 for ; Thu, 17 May 2007 14:20:36 -0300 (ADT) Received: (qmail 8536 invoked by uid 60001); 17 May 2007 17:20:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=14zAyba30in6RLq6h0HWQ9i528oG7ebkYfSEEo+IWty5x+OFI8CiTJr3Qk+V6kSCSiiHtD+Xnaod7yZzs2f4HvpDFIYwtMKqFYcH4D/K+fDehU0OkjihwCBOoUYH86XyJyjrKDXklKK03WDqZedjiVxWIV96efUpQqLu810u5g0=; X-YMail-OSG: y9bdDgcVM1mWLvGcj7aVdFEA2sXOcK4KFbeQmu2QIaQDs7gHXcX84iuNt_WZCVwFHAuMCTKxBA-- Received: from [63.203.180.122] by web31803.mail.mud.yahoo.com via HTTP; Thu, 17 May 2007 10:20:35 PDT Date: Thu, 17 May 2007 10:20:35 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Whole-row comparison ? To: christian.roche.ext@nsn.com Cc: SQL Postgresql List In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <473557.7523.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.736 tagged_above=0 required=5 tests=AWL=-0.020, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: X-Archive-Number: 200705/139 X-Sequence-Number: 28419 --- christian.roche.ext@nsn.com wrote: > select * from temp."BSC_Table" t, public.bsc_view p where t.id = p.id > and row(t) <> row(p); > > ERROR: operator does not exist: "temp"."BSC_Table" <> bsc_view > SQL state: 42883 > Hint: No operator matches the given name and argument type(s). You may > need to add explicit type casts. > Don't forget to reply all so that everyone on the list can participate. Also, do this is good since it doesn't limit you to my limited knowledge. ;) row() doesn't do what you think it does. you have to specify every column that you want to compare, so: row(t.col1, t.col2, t.col3, t.col4) <> row(p.col1, p.col2, p.col3, p.col4) where the datatypes of each respective column match. i.e. t.col1 maps to p.col1, ... Regards, Richard Broersma Jr.