Apples and Oranges, Part II: A Linux DBMS Comparison - page 2

The Database Design

November 18, 1999

By
Matthias Warkus

The difficulties I encountered when I fed the ANSI-compliant CREATE
TABLE statements into PostgreSQL's psql monitor program
were only minor. I received some warnings that foreign key constraints were
accepted but not yet implemented, and I had to cut the COMMENT
field in RATING back to 255 characters since this is the maximum
field width for a CHARACTER VARYING field in PostgreSQL. The
system provides BLOB data types for storing larger amounts of data, but those
aren't in the standard version so I decided not to use them. Another issue is
rather ugly--since I couldn't find information about how PostgreSQL casts
NUMERICs from and into C data types and since I didn't want to use
floats anyway to avoid round-off errors, I decided to make the
monetary field integer numbers of cents.