Mercurial > gemma
changeset 1781:0a53c33bc7b2
Fixed broken SQL statement (once again).
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 11 Jan 2019 16:49:55 +0100 |
parents | 48791416bea5 |
children | 30c76168e6d0 |
files | pkg/imports/agm.go |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/imports/agm.go Fri Jan 11 16:48:14 2019 +0100 +++ b/pkg/imports/agm.go Fri Jan 11 16:49:55 2019 +0100 @@ -75,7 +75,8 @@ ), to_delete AS ( SELECT o.id AS id - FROM waterway.gauge_measurements oJOIN waterway.gauge_measurements n + FROM waterway.gauge_measurements o + JOIN waterway.gauge_measurements n ON n.fk_gauge_id = o.fk_gauge_id AND n.measure_date = o.measure_date WHERE n.id IN (SELECT key FROM staged) AND o.id NOT IN (SELECT key FROM staged)