Re: what is wrong with this SQL?

kornale@zdnetmail.com (Alex K.) writes:

> create table USERS (
>     ID                decimal(19)    CONSTRAINT primary_usr_oid    PRIMARY KEY,
>     WRITE_COUNT            decimal(19)    NOT NULL,
>     CLASS                decimal(10)    NOT NULL,
>     STATUS                decimal(3)    NOT NULL,

> when i am in psql and i do: \i createUsersTable.sql i get this error:
> psql:createUsersTable.sql:13: ERROR:  parser: parse error at or near "("

PostgreSQL DECIMAL doesn't take a size argument.  Take out the sizes
and you'll be good.

-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm.    -Dylan