Data Type
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
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:
Show quoted text
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, 8Many thanks in advance.
---
Regards,
Chris Lee---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org