Re: what is wrong with this SQL?

Is 'varchar2' a proper user-defined type?

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: kornale(at)zdnetmail(dot)com (Alex K.)
> Organization: http://groups.google.com/
> Date: 20 Sep 2001 15:18:46 -0700
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] what is wrong with this SQL?
>
> 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
>