Re: [SQL] Wierd stuff - Mailing list pgsql-sql

From Mario Jorge Nunes Filipe
Subject Re: [SQL] Wierd stuff
Date
Msg-id 384CD92F.2B15EFD7@neptuno.uevora.pt
Whole thread Raw
In response to Re: [SQL] Wierd stuff  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Assaf Gottlieb"
Date:
Subject: OLE-DB vs. ODBC performance on SQL Server 7.0:
Next
From: Max Buvry
Date:
Subject: subquery, except and view