川川的博客

需求 CREATE OR REPLACE FUNCTION “bi”.“zip”(“array1” anyarray, “array2” anyarray) RETURNS “pg_catalog”.“anyarray” AS $BODY$ SELECT ARRAY_AGG(ARRAY[a,b]) FROM unnest(array1,array2) x(a,b); $BODY$ LANGUAGE sql VOLATILE COST 100 版本PostgreSQL 9.4及以上 ...

` CREATE TABLE aaa( – pg10新特性， id int generated always as identity (cache 100 START WITH 1 INCREMENT BY 1) primary key , id2 serial8, c1 varchar(8) ) INSERT INTO aaa(c1) values(‘第一行’); ALTER TABLE aaa ADD COLUMN c2 int; – 多列共用自增 ALTER TABLE aaa ALTER COLU

转自：https://bbs.csdn.net/topics/392389383 UPDATE tb1 SET score = COALESCE( b.scorea,0) from tb1 a left join tb2 b on a.ids=b.ida where a.ids = tb1.ids;

select (select relname as comment from pg_class where oid=a.attrelid) as table_name, row_number() over(partition by (select relname as comment from pg_class where oid=a.attrelid) order by a.attnum)...

SELECT generate_series(1,12) AS month; SELECT generate_series(1,12,1) AS month; SELECT generate_series(‘2020-01-01’::DATE,‘2020-12-31’::DATE,‘1 month’::INTERVAL) AS first_of_month;