Re: What's wrong with this SQL?

Adam wrote:
> I'm trying to create a table and I'm getting this error:
>
>      SQL error:
>
>
> ERROR:  syntax error at or near "(" at character 39
>      In statement:
>      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"))

"privilege" integer(2) NOT NULL

Postgres doesn't support integers of different sizes like this.

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

--
Postgresql & php tutorials
http://www.designmagick.com/