From 4e1f2453318b0e4548c4ec0bfb74b183fc47ee7f Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 30 Jul 2020 23:39:55 +0200 Subject: [PATCH] make house number reappear in display name on named POIs After 6cc6cf950c3c08103e6159a079c85b5a4f1c09fa names and house numbers of POIS got mingled into a single item when creating the display name. Add the house number as extra information without place_id to avoid later mangling. --- sql/functions/address_lookup.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/functions/address_lookup.sql b/sql/functions/address_lookup.sql index 55fa23f2..42c015bf 100644 --- a/sql/functions/address_lookup.sql +++ b/sql/functions/address_lookup.sql @@ -272,7 +272,7 @@ BEGIN END IF; IF searchhousenumber IS NOT NULL THEN - location := ROW(in_place_id, null, null, hstore('ref', searchhousenumber), + location := ROW(null, null, null, hstore('ref', searchhousenumber), 'place', 'house_number', null, null, true, true, 28, 0)::addressline; RETURN NEXT location; END IF; -- 2.39.5