diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-01-17 18:33:56 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-01-17 20:33:37 +0000 |
| commit | 9f1dfacb0f236da5f0413ac20e3376388df7d798 (patch) | |
| tree | 9b4c52f35b8ee0215d4911a786efed382d803942 /src/sql/accessLogPurgeOld.sql | |
| parent | 30a9d45f5322a63c2adf1de7a248ba3a9a0c3903 (diff) | |
| download | webstat-9f1dfacb0f236da5f0413ac20e3376388df7d798.tar.bz2 webstat-9f1dfacb0f236da5f0413ac20e3376388df7d798.tar.xz webstat-9f1dfacb0f236da5f0413ac20e3376388df7d798.zip | |
pg_format schema.sql and sql/*.sql
No changes.
Diffstat (limited to 'src/sql/accessLogPurgeOld.sql')
| -rw-r--r-- | src/sql/accessLogPurgeOld.sql | 19 |
1 files changed, 13 insertions, 6 deletions
diff --git a/src/sql/accessLogPurgeOld.sql b/src/sql/accessLogPurgeOld.sql index 8379018..18ec775 100644 --- a/src/sql/accessLogPurgeOld.sql +++ b/src/sql/accessLogPurgeOld.sql @@ -1,11 +1,18 @@ WITH scope AS ( - SELECT id - FROM access_log - ORDER BY id + SELECT + id + FROM + access_log + ORDER BY + id LIMIT ? -), scoperange AS ( - SELECT min(id) minid, max(id) maxid - FROM scope) +), +scoperange AS ( + SELECT + min(id) minid, + max(id) maxid + FROM + scope) DELETE FROM access_log USING scoperange WHERE request_time < CURRENT_DATE - ?::interval AND access_log.id BETWEEN scoperange.minid AND scoperange.maxid |