Re: what is wrong with this SQL?

On 20 Sep 2001, Alex K. wrote:

> 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,
>     USR_LOGIN_USER_ID        varchar2(16)    ,
>     USR_PASSWORD            varchar2(16)    ,
>     USR_PERSON_FIRST_NAME        varchar(32)    ,
>     USR_PERSON_MIDDLE_NAME        varchar(32)    ,
>     USR_PERSON_LAST_NAME        varchar(32)    ,
>     USR_PERSON_SALUTATION        varchar(32)    ,
>     USR_PERSON_SUFFIX        varchar(32)
> );
>
> 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 "("
>
> What is this?

What is varchar2?  It's probably complaining that it has a type that
isn't there followed by a () size spec and gets confused at that point.