Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3C6BD9FB2E2 for ; Tue, 31 Oct 2006 17:50:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 58342-01-8 for ; Tue, 31 Oct 2006 21:49:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 407449FB406 for ; Tue, 31 Oct 2006 17:49:41 -0400 (AST) Received: from alvh.no-ip.org (201-220-123-102.bk10-dsl.surnet.cl [201.220.123.102]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k9VLnWeV002973; Tue, 31 Oct 2006 13:49:33 -0800 Received: by alvh.no-ip.org (Postfix, from userid 1000) id C07ACC29696; Tue, 31 Oct 2006 18:49:27 -0300 (CLST) Date: Tue, 31 Oct 2006 18:49:27 -0300 From: Alvaro Herrera To: George Pavlov Cc: Andrew Sullivan , pgsql-sql@postgresql.org Subject: Re: record datatype comparisons Message-ID: <20061031214927.GF12008@alvh.no-ip.org> Mail-Followup-To: George Pavlov , Andrew Sullivan , pgsql-sql@postgresql.org References: <20061031212253.GD20809@phlogiston.dyndns.org> <8C5B026B51B6854CBE88121DBF097A8655CBFB@ehost010-33.exch010.intermedia.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8C5B026B51B6854CBE88121DBF097A8655CBFB@ehost010-33.exch010.intermedia.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 31 Oct 2006 13:49:33 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/260 X-Sequence-Number: 26649 George Pavlov wrote: > thanks fo the reply. i was misled by pgAdmin (1.6) giving both as > "record" in the datatype (i thought "row" and "?column?" were just "best > guess" column headers). > > so, if they are indeed differently shaped is there any way to make them > be the same shape? > > note that this one also fails with the same error (one would think these > are the "same shape"): > > select > (select (1,2)) > is distinct from > (select (1,2)) > ; This one works: alvherre=# select row(1,2) is distinct from row(1,2) ; ?column? ---------- f (1 fila) Is that what you're after? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.