"terry" <94487...@qq.com> writes:
> TEST=# CREATE TABLE B (C NUMERIC(8,3));
> CREATE TABLE
> TEST=# INSERT INTO B VALUES (12345.678);
> INSERT 0 1
> TEST=# SELECT * FROM B;
> c
> ---
> 12345.678
> (1 row)
> TEST=# ALTER TABLE B ALTER COLUMN C TYPE NUMERIC(4,0);
> ERROR: numeric
The following bug has been logged online:
Bug reference: 4973
Logged by: terry
Email address: 94487...@qq.com
PostgreSQL version: 8.3.3
Operating system: linux
Description:number precision or scale lost when altering table
column
Details:
Welcome to psql 8.3.3, the
