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 = \ |