From 6159331acfbe2d08361947324e09e446138c7bc1 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 c5e11a6699f..626d35514cc 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.30.2