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: m3wv2kzfvs.fsf@belphigor.mcnaught.org (view raw or flat)
Thread:
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.

-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

In response to

Responses

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-2014 The PostgreSQL Global Development Group