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

Commitd98039d

Browse files
committed
Document that after triggers that need to see changed rows should not be
marked stable.
1 parent99419d3 commitd98039d

File tree

1 file changed

+4
-2
lines changed

1 file changed

+4
-2
lines changed

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

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.90 2010/02/14 01:01:35 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.91 2010/02/25 22:24:00 momjian Exp $
33
-->
44

55
<refentry id="SQL-CREATEFUNCTION">
@@ -289,7 +289,9 @@ CREATE [ OR REPLACE ] FUNCTION
289289
return the same result for the same argument values, but that its
290290
result could change across SQL statements. This is the appropriate
291291
selection for functions whose results depend on database lookups,
292-
parameter variables (such as the current time zone), etc. Also note
292+
parameter variables (such as the current time zone), etc. (It is
293+
inappropriate for <literal>AFTER</> triggers that wish to
294+
query rows modified by the current command.) Also note
293295
that the <function>current_timestamp</> family of functions qualify
294296
as stable, since their values do not change within a transaction.
295297
</para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp