Mercurial > gemma

comparison pkg/imports/st.go @ 1912:a24d3b4b7ccd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Stretch import: Fixed insert SQL statement.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Jan 2019 17:54:18 +0100
parents 6ffc372cde1e
children 8750f50b6cee
comparison
equal deleted inserted replaced
1911:6ffc372cde1e 1912:a24d3b4b7ccd
81 relation = 'waterway.stretches'::regclass)` 81 relation = 'waterway.stretches'::regclass)`
82 82
83 stInsertSQL = ` 83 stInsertSQL = `
84 WITH r AS ( 84 WITH r AS (
85 SELECT isrsrange( 85 SELECT isrsrange(
86 isrs( 86 ( $1::char(2),
87 $1::char(2),
88 $2::char(3), 87 $2::char(3),
89 $3::char(5), 88 $3::char(5),
90 $4::char(5), 89 $4::char(5),
91 $5::int), 90 $5::int),
92 isrs( 91 ( $6::char(2),
93 $6::char(2),
94 $7::char(3), 92 $7::char(3),
95 $8::char(5), 93 $8::char(5),
96 $9::char(5), 94 $9::char(5),
97 $10::int)) AS r 95 $10::int)) AS r
98 ) 96 )