There is no NUMBER data type. I believe you want to use the NUMERIC data
type.
-Edwin Grubbs
On Wed, 6 Feb 2002 [EMAIL PROTECTED] wrote:
> Ivan Handler ([EMAIL PROTECTED]) 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 chttest using createdb with no problems. I then went
>into psql using chttest and did a \i /var/tmp/CHTdbNew.ddl which is the script I
>created. It created all of the tables (28 of them) that do not start with the
>string, "Clinic" and rejected the 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 been all through this and had another programmer
>look at it, and we can find no other reason than the name. It is a pretty weird bug
>or a very subtle script problem that I can not see. I have just started to use
>PostGreSQL, so it could be me. 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")
> );
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
