Mercurial > gemma
changeset 784:5616c6bfb186
Search: show more human readable results for rkm.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Wed, 26 Sep 2018 16:00:32 +0200 |
parents | ab9604a46075 |
children | 1d8ccdb532de |
files | pkg/controllers/search.go |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/search.go Wed Sep 26 15:29:17 2018 +0200 +++ b/pkg/controllers/search.go Wed Sep 26 16:00:32 2018 +0200 @@ -12,7 +12,7 @@ const ( searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]') -FROM (SELECT location_code::text AS name, +FROM (SELECT (location_code).hectometre || ' rhm' AS name, ST_AsGeoJSON(geom)::json AS geom FROM waterway.distance_marks WHERE (location_code).hectometre = $1) r`