set_data_type.patch
text/x-patch
Filename: set_data_type.patch
Type: text/x-patch
Part: 0
Patch
Format: unified
| File | + | − |
|---|---|---|
| doc/src/sgml/ref/alter_table.sgml | 2 | 1 |
diff --git i/doc/src/sgml/ref/alter_table.sgml w/doc/src/sgml/ref/alter_table.sgml
index 8129157..ef59db0 100644
--- i/doc/src/sgml/ref/alter_table.sgml
+++ w/doc/src/sgml/ref/alter_table.sgml
@@ -187,7 +187,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
This form changes the type of a column of a table. Indexes and
simple table constraints involving the column will be automatically
converted to use the new column type by reparsing the originally
- supplied expression.
+ supplied expression. Note this will remove the column's statistics
+ so will normally be followed by an <link linkend="sql-analyze"><command>ANALYZE</command></link> of the table.
The optional <literal>COLLATE</literal> clause specifies a collation
for the new column; if omitted, the collation is the default for the
new column type.