1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
-- This function take two arguments. The first is the "given string" and
-- must not be null. The second argument is the "compare string" and may
-- or may not be null. If the second string is null, the value returned is
-- 3, otherwise it is the levenshtein difference between the two.
-- Change 2010-10-18 Regina Obe - name verbose to var_verbose since get compile error in PostgreSQL 9.0
CREATE OR REPLACE FUNCTION nullable_levenshtein(VARCHAR, VARCHAR) RETURNS INTEGER
AS $_$
DECLARE
given_string VARCHAR;
result INTEGER := 3;
var_verbose BOOLEAN := FALSE; /**change from verbose to param_verbose since its a keyword and get compile error in 9.0 **/
BEGIN
IF $1 IS NULL THEN
IF var_verbose THEN
RAISE NOTICE 'nullable_levenshtein - given string is NULL!';
END IF;
RETURN NULL;
ELSE
given_string := $1;
END IF;
IF $2 IS NOT NULL AND $2 != '' THEN
result := levenshtein_ignore_case(given_string, $2);
END IF;
RETURN result;
END
$_$ LANGUAGE plpgsql IMMUTABLE COST 10;
|
