Rainer Klute <[EMAIL PROTECTED]> writes:
> Here's an Oracle example:

> create table BUSINESS_PROCESS
>         (ID NUMBER not null primary key,
>          BUSINESS_PROTOCOL varchar2(254),
>          PROTOCOL_VERSION varchar2(254),
>          DEFAULT_CONVERSATION_TIMEOUT NUMBER);

Oh, just another nonstandard datatype name then.  You could use CREATE
DOMAIN to create NUMBER as an alias for integer (or bigint or numeric,
depending on what range of values you're expecting).

varchar2 is harder since we don't have any provision for precision
options on domains.  You'll pretty much have to search-and-replace
that to varchar in your schema file :-(

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to