aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--doc/src/sgml/plpgsql.sgml8
1 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index ba2c57b6871..4840f6ea9c6 100644
--- a/doc/src/sgml/plpgsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -5115,7 +5115,7 @@ BEGIN
ELSE
RETURN pos + beg_index - 1;
END IF;
- ELSE
+ ELSIF beg_index < 0 THEN
ss_length := char_length(string_to_search);
length := char_length(string);
beg := length + beg_index - ss_length + 2;
@@ -5132,6 +5132,8 @@ BEGIN
END LOOP;
RETURN 0;
+ ELSE
+ RETURN 0;
END IF;
END;
$$ LANGUAGE plpgsql STRICT IMMUTABLE;
@@ -5170,7 +5172,7 @@ BEGIN
ELSE
RETURN beg;
END IF;
- ELSE
+ ELSIF beg_index < 0 THEN
ss_length := char_length(string_to_search);
length := char_length(string);
beg := length + beg_index - ss_length + 2;
@@ -5191,6 +5193,8 @@ BEGIN
END LOOP;
RETURN 0;
+ ELSE
+ RETURN 0;
END IF;
END;
$$ LANGUAGE plpgsql STRICT IMMUTABLE;