Re: BUG #1305: can't use the type 'number' with alter table

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

>
> The following bug has been logged online:
>
> Bug reference: 1305
> Logged by: Kroly Segesdi
>
> Email address: jazzkutya(at)wom(dot)hu
>
> PostgreSQL version: 7.4.5
>
> Operating system: slackware 10.0
>
> Description: can't use the type 'number' with alter table
>
> Details:
>
> somedb=# 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=# alter table sometbl add column msisdn decimal(11);
> ALTER TABLE
>
> The documentation says theese two types are the same, but it's annoying that
> 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.