Mercurial > gemma

diff pkg/controllers/search.go @ 3584:7b15a6dd4ae5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
search: replace commata via SQL
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 04 Jun 2019 09:50:24 +0200
parents 571801483a70
children 02951a62e8c6
line wrap: on
line diff
--- a/pkg/controllers/search.go	Mon Jun 03 18:37:12 2019 +0200
+++ b/pkg/controllers/search.go	Tue Jun 04 09:50:24 2019 +0200
@@ -27,7 +27,7 @@
 const (
 	searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]')
 FROM (SELECT (location_code).hectometre || ' rhm' AS name,
-			concat(location_code) AS locationcode,
+			replace(concat(location_code), ',','') AS locationcode,
              ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type
       FROM waterway.distance_marks_virtual
       WHERE (location_code).hectometre = $1) r`