Received: from neptuno.uevora.pt (neptuno.sc.uevora.pt [193.136.216.24]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA99948 for ; Tue, 7 Dec 1999 04:54:44 -0500 (EST) (envelope-from mjnf@neptuno.sc.uevora.pt) Received: from neptuno.uevora.pt (really [127.0.0.1]) by neptuno.uevora.pt via smail with esmtp (ident mjnf using rfc1413) id (Debian Smail3.2.0.102) for ; Tue, 7 Dec 1999 09:53:52 +0000 (WET) Sender: mjnf Message-ID: <384CD92F.2B15EFD7@neptuno.uevora.pt> Date: Tue, 07 Dec 1999 09:53:51 +0000 From: Mario Jorge Nunes Filipe Reply-To: mjnf@uevora.pt Organization: Universidade de Evora X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: pt,en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Wierd stuff References: <18398.944493242@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > Yup, that's what I suspected. Hashing 2-byte and 4-byte integers > doesn't deliver the same result --- at least not all the time, there > are special cases such as zero. So this explains all your observed > misbehaviors. > > You can work around it for now by remaking the tables with consistent > data types. OK! Thanks... -- Mario Filipe mjnf@uevora.pt http://neptuno.sc.uevora.pt/~mjnf