Is 'varchar2' a proper user-defined type? Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"
> From: [EMAIL PROTECTED] (Alex K.) > Organization: http://groups.google.com/ > Date: 20 Sep 2001 15:18:46 -0700 > To: [EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
