Re: what is wrong with this SQL?

Hi Alex,
You are using the non standard  VARCHAR2 data type, only Oracle uses
this data type I wonder to know
the difference between VARCHAR and VARCHAR2, anyway try to change it to
VARCHAR.

I hope this help you.
Jose

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?
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>