Re: [SQL] Wierd stuff

From: Mario Jorge Nunes Filipe <mjnf(at)neptuno(dot)sc(dot)uevora(dot)pt>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Wierd stuff
Date: 1999-12-07 09:53:51
Message-ID: 384CD92F.2B15EFD7@neptuno.uevora.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)uevora(dot)pt
http://neptuno.sc.uevora.pt/~mjnf

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Max Buvry 1999-12-07 14:43:54 subquery, except and view
Previous Message kaiq 1999-12-06 18:55:05 RE: [SQL] getting table info