Mercurial > dive4elements > river
comparison etl/src/main/resources/sql/flys-common.properties @ 7193:7fabae60428b double-precision
Merged changes from default into double-precision branch.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 27 Sep 2013 17:36:50 +0200 |
| parents | e5675e85ac38 |
| children |
comparison
equal
deleted
inserted
replaced
| 7016:28748bb1b676 | 7193:7fabae60428b |
|---|---|
| 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 = \ |