<![CDATA[Latest posts for the topic "cast md5 hash to bigint"]]> http://forums.enterprisedb.com/posts/list/7.page JForum - http://www.jforum.net cast md5 hash to bigint
select convert(bigint, convert(binary( 8 ), hashbytes('md5', 'foo')))

Result:
-5999611798422882212

How would I do the same in GridSQL?

Thanks.
Don
]]> http://forums.enterprisedb.com/posts/preList/1541/5397.page http://forums.enterprisedb.com/posts/preList/1541/5397.page GMT Re:cast md5 hash to bigint If your IDs can be hex or text strings, you can do the following:
select md5('foo');
md5
----------------------------------
acbd18db4cc2f85cedef654fccc4a4d8
(1 row)

Direct conversion of this value to a bigint causes an overflow. Will post an update if I find any alternate way to convert hex value to bigint.

--
Atul]]> http://forums.enterprisedb.com/posts/preList/1541/5400.page http://forums.enterprisedb.com/posts/preList/1541/5400.page GMT