Re: what is wrong with this SQL?

The difference between VARCHAR and VARCHAR2 in ORACLE is that VARCHAR2 is
ORACLE's UNICODE character data type - equiv to NCHAR in PostgreSQL.

Andy.

<zammon(at)libero(dot)it> wrote in message news:3BB380F9(dot)7000106(at)libero(dot)it(dot)(dot)(dot)
> 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
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html