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.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
