Re: Alternative to "Money" ... - Mailing list pgsql-admin

From Matt Clark
Subject Re: Alternative to "Money" ...
Date
Msg-id OAEAKHEHCMLBLIDGAFELAEECEJAA.matt@ymogen.net
Whole thread Raw
In response to Re: Alternative to "Money" ...  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: Alternative to "Money" ...  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
> .. 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


pgsql-admin by date:

Previous
From: Chris Gamache
Date:
Subject: Re: Alternative to "Money" ...
Next
From: Tom Lane
Date:
Subject: Re: pg_dump privileges