Horton

Re: Money type not gone?

Andreas Pflug <pgadmin@pse-consulting.de>

View thread
From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Josh Berkus <josh@agliodbs.com>, pgsql-bugs@postgresql.org
Date: 2004-09-20T10:04:51Z
Lists: pgsql-bugs 
Karel Zak wrote:
> On Mon, 2004-09-20 at 08:36 +0000, Andreas Pflug wrote:
> 
>>Karel Zak wrote:
>>
>>>On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote:
>>>
>>
>>> I want to rewrite it for 8.1 as numeric based datetype with some
>>>formatting extension probably with some internal stuff from to_char()
>>>familly.
>>
>>How about a type that is also able to hold an ISO currency identifier?
> 
> 
> My idea is special internal API that will usable for new datetypes
> programming if type is defined as "numeric + symbol", for example things
> like speed, weight, currency.. etc.

A type consisting of value and unit probably makes pgsql even more first 
choice for technical applications. Please note that %, k, M and so on 
are scales, not units and thus dont belong into that type.

Regards,
Andreas