Hi,
boolean is supported in PostgreSQL. ANSI SQL should be all right. If you have
problems it might help, when you post the exact statement with the
corrosponding error-message here.
I don't know Rational Rose, but I know S-Designor/Power-Designer. There you
could write your own logical-to-physical-typemappings.
Tommi
Am Mittwoch, 28. August 2002 11:50 schrieb Chris Lee:
> Hi,
>
> I am trying to use Rational Rose for creating Data Model.
>
> Since the software does not native support PostgreSQL, so I choose ANSI SQL
> 92 as target database. But I found that the data type support was very
> limited (e.g. no boolean data type).
>
> Can anyone kindly suggest me which of the following DBMS support data type
> close to PostgreSQL?
>
> IBM DB2
> MS SQL 6, 7, 2K
> Oracle 7, 8
>
> Many thanks in advance.
>
> ---
> Regards,
> Chris Lee
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org