CREATE TYPE example needed

From: "Jim Buttafuoco" <jim(at)spectrumtelecorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE TYPE example needed
Date: 2003-01-15 18:40:50
Message-ID: 200301151840.h0FIeoZ28139@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

I am looking for a way to create a VARCHAR2 (oracle) type so I can use the same SQL to create my tables in either Oracle
or Postgresql. Does anyone have a working example?

I have tried the following with no luck

create type varchar2 (input=varcharin,output=varcharout,INTERNALLENGTH=VARIABLE);
ERROR: TypeCreate: function 'varcharin(opaque)' does not exist

Thanks

Jim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Seidman 2003-01-15 18:41:50 Re: last word in text
Previous Message Petre Scheie 2003-01-15 18:38:50 gmake check error on HPUX