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

From: Segesdi Kroly <vrm(at)wom(dot)hu>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1305: can't use the type 'number' with alter table
Date: 2004-11-03 18:56:04
Message-ID: 418929C4.7010005@wom.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-11-03 22:50:36 Re: could not find /usr/local/timezone
Previous Message Stephan Szabo 2004-11-03 18:50:10 Re: BUG #1305: can't use the type 'number' with alter table