On Wed, 3 Nov 2004, PostgreSQL Bugs List wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1305
> Logged by: Károly Segesdi
>
> Email address: [EMAIL PROTECTED]
>
> 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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
