1ヶ月の降水量を各時間ごとに累積

データ

SQL

SELECT datetime, precipitation,
              SUM(precipitation) OVER(ORDER BY datetime ASC) AS sum_precipitation
FROM rainfalls
WHERE  datetime >= '2018-06-01 00:00' AND datetime < '2018-07-01 00:00'
ORDER BY datetime

計算後

INSERT INTO update_schedules (name, age) VALUES ('Yoo', '26') RETURNING id;

SELECT 
origin.*,
pg_class.oid as foreign_class_id,
pg_class.relname as foreign_relname,
pg_attribute.attnum as foreign_attnum,
pg_attribute.attname as foreign_attname
FROM 
(
SELECT 
pg_constraint.conrelid
, pg_class.oid as pg_class_id
, pg_class.relname
, pg_attribute.attnum
, pg_attribute.attname
, pg_constraint.confrelid
, pg_constraint.confkey
, pg_constraint.contype
FROM  pg_constraint
            LEFT JOIN pg_attribute ON pg_constraint.conrelid = pg_attribute.attrelid AND pg_attribute.attnum = ANY(pg_constraint.conkey)
            LEFT JOIN pg_class ON pg_constraint.conrelid = pg_class.oid
WHERE pg_constraint.contype = 'f' AND pg_constraint.conrelid = 'pg_classのID'
) AS origin
  LEFT JOIN pg_attribute ON origin.confrelid = pg_attribute.attrelid AND pg_attribute.attnum = ANY(origin.confkey)
  LEFT JOIN pg_class ON origin.confrelid = pg_class.oid
;