我有一个单位表和一个报告表。一个单位有很多报告。因此reports表有一个外键unit_id,它对应于单元的id。因此,reports表中有一个外键约束。 ERROR: insert or update on table "reports" violates foreign key constraint "reports_unit_id_fkey"
Detail: Key (unit_id)=(7295) is not present in
所谓缓存,我的意思是,是否对每个获取的行都调用了子查询?-- Simple query SELECT * FROM accountsSELECT * FROM () AS subquery;
SELECT * FROM (
SELECT id_groups, AVG(id_accounts) OVER (PARTITION B