Thread: What's wrong about this sql statement?

I am newbie. Try to create a table like this.

CREATE TABLE usersright (
    userid INTEGER NOT NULL,
    rightid INTEGER NOT NULL,
    allow BOOLEAN NOT NULL DEFAULT FALSE
CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
);

But I got the following error message:

ERROR: parser: parse error at or near "("

I am following the syntax of SQL statement reference from postgresql web
site.

please help.

thx.

corn

On Fri, Aug 31, 2001 at 03:58:45PM +0800, Corn wrote:
> I am newbie. Try to create a table like this.
>
> CREATE TABLE usersright (
>     userid INTEGER NOT NULL,
>     rightid INTEGER NOT NULL,
>     allow BOOLEAN NOT NULL DEFAULT FALSE
> CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
> );
>
> But I got the following error message:
>
> ERROR: parser: parse error at or near "("
>
> I am following the syntax of SQL statement reference from postgresql web
> site.

Not quite. You need another comma after the FALSE:

CREATE TABLE usersright (
    userid INTEGER NOT NULL,
    rightid INTEGER NOT NULL,
    allow BOOLEAN NOT NULL DEFAULT FALSE,
CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
);

Richard