postgres_pearls
converting an hex string into a bigint
select ('x'||lpad(substr(md5('haha'),1,8),16,'0'))::bit(64)::bigint
Keyword: hex conversion integer int hash
postgres_pearls.txt · Last modified: 2024/04/11 14:23 by 127.0.0.1