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
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:ca
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