Search Postgresql Archives

Re: Money casting too liberal?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 31/3/13 at 5:20 AM, D'Arcy J.M. Cain wrote:

On Sun, 31 Mar 2013 21:57:49 +1100 Gavan Schneider wrote:
On 30/3/13 at 12:58 AM, D'Arcy J.M. Cain wrote:
That seems extreme.  What use case would there ever be for making a
column always debit or always credit?  I have a G/L system and most
money columns either don't know about Dr/Cr or else there is another
column with the G/L account which implies Dr/Cr.  Where do you see a
column that would be dedicated to one or the other?

If you have a credit card and a bank account you are already familiar with the concept of Debit and Credit columns. If the

I am *very* familiar with debit and credit columns.  In addition, I
don't confuse columns on a display or piece of paper with columns in a
database.

OK. My assumption was that my previous comment was not understood and I needed to plod through a basic example to make my meaning clear. While English is my first language I don't claim perfection in its usage.

....

it can't do that then nobody is going to bother using it for serious work since NUMERIC and INTEGER will do the job just as well without the surprises.

What surprises?  It is much faster than numeric and it does the
formatting for you rather than requiring code like integer would.
Other than that they fail your test exactly like the money type.

Sorry. I know you authored the type. And mine are not the only comments along these lines.

The MONEY type is in the system and any and all are welcome to use it as is. From the discussion it does not suite many and my only motive was to explore ways in which it could cover a wider audience without losing its advantages, i.e., speed and specificity.

Regards
Gavan Schneider



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux