Home > mailing lists

CREATE TYPE example needed - Mailing list pgsql-general

From	Jim Buttafuoco
Subject	CREATE TYPE example needed
Date	January 15, 2003 17:30:50
Msg-id	200301151840.h0FIeoZ28139@contactbda.com Whole thread Raw
Responses	Re: CREATE TYPE example needed
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Oleg Bartunov
Date: 15 January 2003, 17:12:55
Subject: Re: [SQL] sort by relevance

From: Petre Scheie
Date: 15 January 2003, 17:30:57
Subject: gmake check error on HPUX

CREATE TYPE example needed - Mailing list pgsql-general

Previous

Next