postgrespro.git / summary / log / commit / refs

commit    7dc6ae37def50b5344c157eee5e029a09359f8ee
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Jun 13 03:05:40 2019 +0000

    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 b80040d0cc..ed2d9c60d5 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 <emphasis>GENERATED ALWAYS AS (height_cm * 2.54) STORED</emphasis>
+    height_in numeric <emphasis>GENERATED ALWAYS AS (height_cm / 2.54) STORED</emphasis>
 );
 </programlisting>
    The keyword <literal>STORED</literal> must be specified to choose the


[parent: 9729c9360886]