【设计改变世界】github地址：https://github.com/guochunyang2004

Postgresql 有以下三种方法设置主键递增的方式，下面来看下相同点和不同点。--方法一create table test_a( id serial, name character varying(128),constraint pk_test_a_id primary key( id));NOTICE: CREATE TABLE will create implicit sequence "test_a_id_seq" for serial column "test_a.id"...

postgresql 构造日期序列SELECT to_char ( d, 'yyyy-mm-dd' ) AS days FROM generate_series ((date(current_date) - interval '7 day'),date(current_date),'1 days' ) AS d2020-07-082020-07-092020-07-102020-07-112020-07-122020-07-132020-07-142020-07-15...

CREATE or REPLACE FUNCTION new_guid() RETURNS "pg_catalog"."varchar" AS $BODY$ DECLARE v_seed_value varchar(32); BEGIN select md5( inet_client_addr()::varchar || timeofday() || inet_server_addr()::varchar || t...