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
