From 4cbd8c60223bd28aacb38f8c8921fc5b8a704fcd Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed, 17 Jul 2024 15:17:52 -0400
Subject: [PATCH] Doc: fix minor syntax error in example.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

The CREATE TABLE option is GENERATED BY DEFAULT *AS* IDENTITY.

Per bug #18543 from Ondřej Navrátil.  Seems to have crept in
in a37bb7c13, so back-patch to v17 where that was added.

Discussion: https://postgr.es/m/18543-93c721689f9928e8@postgresql.org
---
 doc/src/sgml/ddl.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 9b71c97bdf1..4240c342616 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -257,7 +257,7 @@ CREATE TABLE people (
    or alternatively
 <programlisting>
 CREATE TABLE people (
-    id bigint <emphasis>GENERATED BY DEFAULT IDENTITY</emphasis>,
+    id bigint <emphasis>GENERATED BY DEFAULT AS IDENTITY</emphasis>,
     ...,
 );
 </programlisting>
-- 
2.39.5