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

Stephan Szabo wrote:

>On Wed, 3 Nov 2004, PostgreSQL Bugs List wrote:
>
>
>>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.
>
>
I'm sorry. It was my fault.