Mercurial > gemma
comparison schema/search_functions.sql @ 3737:e3f15a163823
Fixed typo in search functions.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Mon, 24 Jun 2019 11:52:07 +0200 |
parents | 4cc3b28fd87b |
children | 9f20d2b59d4c |
comparison
equal
deleted
inserted
replaced
3736:4cc3b28fd87b | 3737:e3f15a163823 |
---|---|
70 name) r; | 70 name) r; |
71 RETURN _result; | 71 RETURN _result; |
72 END; | 72 END; |
73 $$; | 73 $$; |
74 | 74 |
75 qCREATE OR REPLACE FUNCTION search_gauges(search_string text) RETURNS jsonb | 75 CREATE OR REPLACE FUNCTION search_gauges(search_string text) RETURNS jsonb |
76 LANGUAGE plpgsql STABLE PARALLEL SAFE | 76 LANGUAGE plpgsql STABLE PARALLEL SAFE |
77 AS $$ | 77 AS $$ |
78 DECLARE | 78 DECLARE |
79 _result jsonb; | 79 _result jsonb; |
80 BEGIN | 80 BEGIN |