There is no NUMBER data type. I believe you want to use the NUMERIC data
type.
-Edwin Grubbs
On Wed, 6 Feb 2002 pgsql-bugs@postgresql.org wrote:
> Ivan Handler (ivan@jaildoc.com) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> can not create tables that start with "Clinic"
>
> Long Description
> First I logged in to my Linux server (latest RH) as root and did a su -l postgres. I created a database called
chttestusing createdb with no problems. I then went into psql using chttest and did a \i /var/tmp/CHTdbNew.ddl which
isthe script I created. It created all of the tables (28 of them) that do not start with the string, "Clinic" and
rejectedthe 5 that do. The error message for all 5 was identical:
> -------------------------------------------
> ERROR: parser: parse error at or near "("
> -------------------------------------------
>
> the line number was always given as the end of the clause. I have included the script for you to inspect. I have
beenall through this and had another programmer look at it, and we can find no other reason than the name. It is a
prettyweird bug or a very subtle script problem that I can not see. I have just started to use PostGreSQL, so it could
beme. I have enclosed the complete script.
>
>
> CREATE TABLE "Clinic"
> (
> "clinicid" SERIAL,
> "name" VARCHAR(30) NOT NULL,
> "cllinicDate" DATE NOT NULL,
> "clinicTime" TIME NOT NULL,
> "serviceid" INTEGER NOT NULL,
> "slots" NUMBER(2),
> "clinictypeid" INTEGER NOT NULL,
> CONSTRAINT "PK_Clinic" PRIMARY KEY ("clinicid")
> );
>