Reference Manual should clarify what ALTER TABLE ADD COLUMN does

The documentation should state explicitly that ALTER TABLE ADD COLUMN adds the new column at the end of the table row. If you need to change a column (for example, to change its data type), the only way to do so is to drop the column and add a new one, and this changes the ordering of the columns.