1 Answer
- Newest
- Most votes
- Most comments
0
【以下的回答经过翻译处理】 虽然没有内置函数,但我写了类似的实现:
create function hash8 (varchar)
returns bigint
immutable
as $$
select strtol(to_hex(strtol(substr(md5($1), 1, 1), 16) & 7) || substr(md5($1), 2, 15), 16)
$$ language sql;
Relevant content
- asked a year ago
- Accepted Answerasked 3 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago