cast md5 hash to bigint

This message was edited 1 time. Last update was at 04/12/2008 13:25:30

In SQL Server, I might do something like this to create IDs for dimensions.

select convert(bigint, convert(binary( 8 ), hashbytes('md5', 'foo')))

Result:
-5999611798422882212

How would I do the same in GridSQL?

Thanks.
Don

Hi Don,
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