Re: [HACKERS] More Hashing questions

2004-05-06 Thread Jim C. Nasby
If you do this I suggest supporting bigint as well. On Tue, May 04, 2004 at 06:45:37PM -0400, Greg Stark wrote: Regarding inter-data-type hash joins, would it make sense to make float datatypes to hash to the same value as integral data types for integral values? Conveniently this would

Re: [HACKERS] More Hashing questions

2004-05-06 Thread Greg Stark
Jim C. Nasby [EMAIL PROTECTED] writes: If you do this I suggest supporting bigint as well. Well I'm not about to actually do the inter-data-type hash joins. I was just asking if the hash functions for floats should be adjusted to guarantee this property. bigints already guarantee it, though I

[HACKERS] More Hashing questions

2004-05-04 Thread Greg Stark
Regarding inter-data-type hash joins, would it make sense to make float datatypes to hash to the same value as integral data types for integral values? Conveniently this would cover the existing special case of -0 and +0 hashing to the same value. Something like this? Datum