Re: CREATE TYPE example needed

"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