diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-06-12 23:05:40 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-06-12 23:05:40 -0400 |
| commit | 7dc6ae37def50b5344c157eee5e029a09359f8ee (patch) | |
| tree | d405dfed4f750261a97073af43bd42e33a240e83 /doc/src | |
| parent | 9729c9360886bee7feddc6a1124b0742de4b9f3d (diff) | |
| download | postgresql-7dc6ae37def50b5344c157eee5e029a09359f8ee.tar.gz postgresql-7dc6ae37def50b5344c157eee5e029a09359f8ee.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
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 <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 |