Re: What's wrong with this SQL?

On May 10, 2006, at 12:06 AM, Adam wrote:

> CREATE TABLE "users" ("user_ID" SERIAL(12), "first_name" character
> varying(40) NOT NULL, "last_name" character varying(40) NOT NULL,
> "password" character varying(16) NOT NULL, "email" character varying
> (100) NOT NULL, "privilege" integer(2) NOT NULL, PRIMARY KEY
> ("user_ID"))

PostgreSQL integers don't have a size property. So SERIAL(12) and
integer(2) are wrong. See the type choices here:

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-
INT



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL