Re: BUG #1305: can't use the type 'number' with alter table - Mailing list pgsql-bugs

On Wed, 3 Nov 2004, PostgreSQL Bugs List wrote:

>
> The following bug has been logged online:
>
> Bug reference:      1305
> Logged by:          K=C3=A1roly Segesdi
>
> Email address:      jazzkutya@wom.hu
>
> PostgreSQL version: 7.4.5
>
> Operating system:   slackware 10.0
>
> Description:        can't use the type 'number' with alter table
>
> Details:
>
> somedb=3D# alter table sometbl add column msisdn number(11);
> ERROR:  syntax error at or near "(" at character 43
>
> you can use the type identifier 'decimal' instead:
> somedb=3D# alter table sometbl add column msisdn decimal(11);
> ALTER TABLE
>
> The documentation says theese two types are the same, but it's annoying t=
hat
> you can't use the one that is mentioned more frequently in the docs.

I think the issue is that the type is numeric, not number.  Where did you
see it refered to as number in the docs so we can fix it.