kornale(at)zdnetmail(dot)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