Mercurial > dive4elements > river
comparison etl/src/main/resources/sql/flys-common.properties @ 6893:60f39ee19473
ETL: Potential fix for flys/1453.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Wed, 21 Aug 2013 16:13:36 +0200 |
parents | 3bb6c2a3ef72 |
children | 389bf6b7d371 |
comparison
equal
deleted
inserted
replaced
6892:e97e710ecf3f | 6893:60f39ee19473 |
---|---|
5 JOIN wst_columns wc ON w.id = wc.wst_id \ | 5 JOIN wst_columns wc ON w.id = wc.wst_id \ |
6 JOIN wst_column_values wcv ON wcv.wst_column_id = wc.id \ | 6 JOIN wst_column_values wcv ON wcv.wst_column_id = wc.id \ |
7 WHERE w.kind = 0 \ | 7 WHERE w.kind = 0 \ |
8 GROUP BY r.id, r.name | 8 GROUP BY r.id, r.name |
9 select.gauges = \ | 9 select.gauges = \ |
10 SELECT id, name, official_number \ | 10 SELECT id, name, official_number, station \ |
11 FROM gauges \ | 11 FROM gauges \ |
12 WHERE river_id = :river_id | 12 WHERE river_id = :river_id |
13 next.gauge.id = \ | 13 next.gauge.id = \ |
14 SELECT NEXTVAL('GAUGES_ID_SEQ') AS gauge_id | 14 SELECT NEXTVAL('GAUGES_ID_SEQ') AS gauge_id |
15 insert.gauge = \ | 15 insert.gauge = \ |