Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2031e16

Browse files
committed
Doc: fix confusion about LEAKPROOF in syntax summaries.
The syntax summaries for CREATE FUNCTION and allied commandsmade it look like LEAKPROOF is an alternative toIMMUTABLE/STABLE/VOLATILE, when of course it is an orthogonaloption. Improve that.Per gripe from aazamrafeeque0. Thanks to David Johnston forsuggestions.Discussion:https://postgr.es/m/162444349581.694.5818572718530259025@wrigleys.postgresql.org
1 parent126cdaf commit2031e16

File tree

3 files changed

+8
-5
lines changed

3 files changed

+8
-5
lines changed

‎doc/src/sgml/ref/alter_function.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -35,7 +35,8 @@ ALTER FUNCTION <replaceable>name</replaceable> [ ( [ [ <replaceable class="param
3535
<phrase>where <replaceable class="parameter">action</replaceable> is one of:</phrase>
3636

3737
CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
38-
IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
38+
IMMUTABLE | STABLE | VOLATILE
39+
[ NOT ] LEAKPROOF
3940
[ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
4041
PARALLEL { UNSAFE | RESTRICTED | SAFE }
4142
COST <replaceable class="parameter">execution_cost</replaceable>

‎doc/src/sgml/ref/alter_routine.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -34,7 +34,8 @@ ALTER ROUTINE <replaceable>name</replaceable> [ ( [ [ <replaceable class="parame
3434

3535
<phrase>where <replaceable class="parameter">action</replaceable> is one of:</phrase>
3636

37-
IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
37+
IMMUTABLE | STABLE | VOLATILE
38+
[ NOT ] LEAKPROOF
3839
[ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
3940
PARALLEL { UNSAFE | RESTRICTED | SAFE }
4041
COST <replaceable class="parameter">execution_cost</replaceable>

‎doc/src/sgml/ref/create_function.sgml

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -28,9 +28,10 @@ CREATE [ OR REPLACE ] FUNCTION
2828
{ LANGUAGE <replaceable class="parameter">lang_name</replaceable>
2929
| TRANSFORM { FOR TYPE <replaceable class="parameter">type_name</replaceable> } [, ... ]
3030
| WINDOW
31-
| IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
32-
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
33-
| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
31+
| { IMMUTABLE | STABLE | VOLATILE }
32+
| [ NOT ] LEAKPROOF
33+
| { CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT }
34+
| { [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER }
3435
| PARALLEL { UNSAFE | RESTRICTED | SAFE }
3536
| COST <replaceable class="parameter">execution_cost</replaceable>
3637
| ROWS <replaceable class="parameter">result_rows</replaceable>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp