> .. I can't _quite_ tell if you're serious or not ... :) > > If you are serious, are you saying to do something like: > > CREATE TABLE new_money (product text, dollars int4, cents int4);
Ha :-) That would not be serious. I'm pretty sure he meant to just store the product cost in cents instead of dollars, e.g. > CREATE TABLE new_money (product text, cents int4); > INSERT INTO new_money (product, cents) values ('Flowbee','1995'); > INSERT INTO new_money (product, cents) values ('Garth Brooks\'s > Greatest Hits','999'); M ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]