PostgreSQL模拟雪花算法生成ID

第一步创建一个序列

CREATE SEQUENCE snow_id_seq increment by 1 maxvalue 99999999 minvalue 1 start 1 cycle;

第二步创建一个函数

CREATE OR REPLACE FUNCTION snow_next_id(OUT result bigint) AS $$
DECLARE
our_epoch bigint := 1314220021721;
seq_id bigint;
now_millis bigint;
shard_id int := 5;
BEGIN
seq_id := nextval('snow_id_seq') % 1024;
SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;
result := (now_millis - our_epoch) << 23;
result := result | (shard_id << 10);
result := result | (seq_id);
END;
$$ LANGUAGE PLPGSQL;

第三步执行下面句子

SELECT snow_next_id();