CREATE TRIGGER document typo

Started by Yugo Nagataover 8 years ago2 messages
#1Yugo Nagata
nagata@sraoss.co.jp
1 attachment(s)

Hi,

Attached is a patch fixing simple typos in the CREATE TRIGGER document.

--
Yugo Nagata <nagata@sraoss.co.jp>

Attachments:

create_trigger_typo.patchtext/x-diff; name=create_trigger_typo.patchDownload
diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml
index 24195b3..c5f7c75 100644
--- a/doc/src/sgml/ref/create_trigger.sgml
+++ b/doc/src/sgml/ref/create_trigger.sgml
@@ -531,8 +531,8 @@ CREATE TRIGGER view_insert
 <programlisting>
 CREATE TRIGGER transfer_insert
     AFTER INSERT ON transfer
-    FOR EACH STATEMENT
     REFERENCING NEW TABLE AS inserted
+    FOR EACH STATEMENT
     EXECUTE PROCEDURE check_transfer_balances_to_zero();
 </programlisting>
 
@@ -543,8 +543,8 @@ CREATE TRIGGER transfer_insert
 <programlisting>
 CREATE TRIGGER paired_items_update
     AFTER UPDATE ON paired_items
-    FOR EACH ROW
     REFERENCING NEW TABLE AS newtab OLD TABLE AS oldtab
+    FOR EACH ROW
     EXECUTE PROCEDURE check_matching_pairs();
 </programlisting>
   </para>
#2Heikki Linnakangas
hlinnaka@iki.fi
In reply to: Yugo Nagata (#1)
Re: CREATE TRIGGER document typo

On 04/17/2017 12:09 PM, Yugo Nagata wrote:

Hi,

Attached is a patch fixing simple typos in the CREATE TRIGGER document.

Applied, thanks!

- Heikki

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers