comparison etl/src/main/resources/sql/flys-common.properties @ 6894:389bf6b7d371

Backed out changeset 60f39ee19473
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 21 Aug 2013 16:14:29 +0200
parents 60f39ee19473
children e5675e85ac38
comparison
equal deleted inserted replaced
6893:60f39ee19473 6894:389bf6b7d371
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, station \ 10 SELECT id, name, official_number \
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 = \

http://dive4elements.wald.intevation.org