Re: [GENERAL] hash options

2012-01-22 Thread dwnoon
This message has been digitally signed by the sender. Re___GENERAL__hash_options.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://

Re: [GENERAL] hash options

2012-01-22 Thread David W Noon
On Sun, 22 Jan 2012 09:59:55 -0600, Little, Douglas wrote about [GENERAL] hash options: >I'm working on a data warehouse dimensionalization process where I >need to hash a text string to use as the key. I've implemented with >MD5. It works fine, the problem I have is the size of the md5 (32 >b

Re: [GENERAL] hash options

2012-01-22 Thread Chris Angelico
On Mon, Jan 23, 2012 at 2:59 AM, Little, Douglas wrote: > > I’ve implemented with MD5.  It works fine,  the problem I have is the size of > the md5 (32 bytes) is often longer than the original string – thus not > accomplishing what I want – space savings. You can always use a truncated hash - f