Twitter Snowflake ID for PostgreSQL

snowflake-id.sql

CREATE SEQUENCE public.snowflake_id_seq;
ALTER SEQUENCE public.snowflake_id_seq OWNER TO postgres;

CREATE OR REPLACE FUNCTION public.snowflake_id()
    RETURNS bigint
    LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
    epoch bigint := 1288834974657;
    seq_id bigint;
    now_millis bigint;
    -- the id of this DB shard, must be set for each
    -- schema shard you have - you could pass this as a parameter too
    shard_id int := 1;
    result bigint:= 0;
BEGIN
    SELECT nextval('public.snowflake_id_seq') % 1024 INTO seq_id;

    SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;
    result := (now_millis - epoch) << 23;
    result := result | (shard_id << 10);
    result := result | (seq_id);
	return result;
END;
$BODY$;

ALTER FUNCTION public.snowflake_id() OWNER TO postgres;

-- SELECT public.snowflake_id()