On Thu, 2022-11-17 at 18:14 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/13/plpgsql-trigger.html
>
> Type alignment issue for salary at "Example 43.4. A PL/pgSQL Trigger
> Function for Auditing":
>
> CREATE TABLE emp_audit(
> operation char(1) NOT NULL,
> stamp timestamp NOT NULL,
> userid text NOT NULL,
> empname text NOT NULL,
> salary integer
> );
Attached is a patch to fix that.
Yours,
Laurenz Albe
From 4cfc7ec4b655a8317a918e3a4a0791433af58a63 Mon Sep 17 00:00:00 2001
From: Laurenz Albe <laurenz.a...@cybertec.at>
Date: Fri, 18 Nov 2022 07:19:30 +0100
Subject: [PATCH] Fix text alignment in an example
---
doc/src/sgml/plpgsql.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index d85f89bf30..e80ab2913f 100644
--- a/doc/src/sgml/plpgsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -4301,7 +4301,7 @@ CREATE TABLE emp_audit(
stamp timestamp NOT NULL,
userid text NOT NULL,
empname text NOT NULL,
- salary integer
+ salary integer
);
CREATE OR REPLACE FUNCTION process_emp_audit() RETURNS TRIGGER AS $emp_audit$
--
2.38.1
