Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE TYPE example needed - Mailing list pgsql-general

From Tom Lane
Subject Re: CREATE TYPE example needed
Date
Msg-id 20528.1042662408@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TYPE example needed  ("Jim Buttafuoco" <jim@spectrumtelecorp.com>)
Responses Re: CREATE TYPE example needed
List pgsql-general
Tree view 
"Jim Buttafuoco" <jim@spectrumtelecorp.com> writes:
> 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?

In 7.3, it's easy to use a "domain" as a type alias.

    CREATE DOMAIN varchar2 AS varchar;

This has the advantage that all the operations on varchar will work for
varchar2.  If you make a real type, you need to provide all those
operations.

Note however that this doesn't give you any special syntax for varchar2.
If you're expecting to be able to write "varchar2(N)" you're still out
of luck...

            regards, tom lane

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: How to ALTER COLUMN to set a constraint of not null?
Next
From: Garo Hussenjian
Date:
Subject: Re: postgres on a PDA