Horton

Re: [SQL] Wierd stuff

Mario Jorge Nunes Filipe <mjnf@neptuno.sc.uevora.pt>

View thread View on postgr.es
From: Mario Jorge Nunes Filipe <mjnf@neptuno.sc.uevora.pt>
To: pgsql-sql@postgreSQL.org
Date: 1999-12-07T09:53:51Z
Lists: 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