Shulou(Shulou.com)06/01 Report--

This article mainly introduces the sql script function to write postgresql database to achieve parsing, the article through the sample code is introduced in great detail, for everyone's study or work has a certain reference learning value, friends in need can refer to the following

Postgresql creates Long self-increasing function

CREATE SEQUENCE global_id_sequence;CREATE OR REPLACE FUNCTION seq_id (OUT result bigint) AS $$DECLARE our_epoch bigint: = 1314220021721; 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 SELECT nextval begin SELECT nextval ('global_id_sequence')% 1024 INTO seq_id; SELECT FLOOR (EXTRACT (EPOCH FROM clock_timestamp ()) * 1000) INTO now_millis Result: = (now_millis-our_epoch)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.