Skip site navigation (1) Skip section navigation (2)

Re: what is wrong with this SQL?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: kornale(at)zdnetmail(dot)com (Alex K(dot))
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: what is wrong with this SQL?
Date: 2001-09-27 17:45:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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.

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

In response to


pgsql-general by date

Next:From: Doug McNaughtDate: 2001-09-27 17:48:59
Subject: Re: what is wrong with this SQL?
Previous:From: David ChristianDate: 2001-09-27 17:36:36
Subject: Re: Quoting '?' placeholder in Perl's DBD::Pg?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group