BG5VXJ 需要跨天查询时不宜这样建表。如果是PostgreSQL，完全可以这样操作：
CREATE TABLE "public"."xxx" (
"id" int8 NOT NULL DEFAULT nextval('xxx_seq'::regclass),
...
"created_at" timestamptz(6) NOT NULL,
...
CONSTRAINT "xxx_pkey" PRIMARY KEY ("id","created_at")
)
PARTITION BY RANGE ("created_at");
CREATE TABLE xxx_202501 PARTITION OF xxx FOR VALUES FROM ('2025-01-01') TO ('2025-02-01');
CREATE TABLE xxx_202502 PARTITION OF xxx FOR VALUES FROM ('2025-02-01') TO ('2025-03-01');
...
操作时直接用xxx表，SQL该怎么写就怎么写，不需要关心它后面是怎么分的。
闽ICP备2021006864号-7
闽公网安备35020602002794号