Ron Johnson wrote:
CREATE TYPE ty_fraction AS ( n SMALLINT, d SMALLINT );
You'd need a type for large integers first - otherwise your ty_fraction will be quite limited. I think numeric could be used for that, though I don't know if numeric guarantees that at least the operators +,-,* and modulo return exact results (Don't loose digits). But even if they do, using some existing library for arbitrary sized integers would probably lead to better performance. greetings, Florian Pflug