From 7dc6ae37def50b5344c157eee5e029a09359f8ee Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 12 Jun 2019 23:05:40 -0400 Subject: [PATCH] Doc: fix bogus example. This wasn't incorrect SQL, but it was doing cm-to-inch conversion backward, so it might confuse readers. Per bug #15849 from TAKATSUKA Haruka. Discussion: https://postgr.es/m/15849-37ad0c561a836107@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 b80040d0cc2..ed2d9c60d50 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -259,7 +259,7 @@ CREATE TABLE products ( CREATE TABLE people ( ..., height_cm numeric, - height_in numeric GENERATED ALWAYS AS (height_cm * 2.54) STORED + height_in numeric GENERATED ALWAYS AS (height_cm / 2.54) STORED ); The keyword STORED must be specified to choose the -- 2.39.5