Subject Re: Money data type
Author Kevin
Could you please elaborate a bit more on the differences between
decimal and numeric and why I would want to "exceed the precision".
What might the syntax look like to create the domain mentioned?

Thanks Again...



--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...> wrote:
>
> I've never heard anyone who knows what they are talking about,
suggest double precision. It's only place would be as an intermediary
value in a stored procedure.
> If you want to constrain the monetary value to a certain precision,
use Numeric. If you want it to be able to exceed the precision, use
Decimal.
> FB doesn't support these distinctions, but I feel it's important to
try to do the correct thing.
> I also use domains that wrap these base data types, and add such
constraints in to the domain.
>
> Rick DeBay
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin
> Sent: Friday, May 19, 2006 3:40 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Money data type
>
> I've read several articles about what the best data type is in
Firebird to store money. Some say Decimal, others Numeric, and yet
others Double Precision.
>
> Many of these articles are quite old (some 5+ years), so I am
interested to see if anything on this topic has changed recently and
what is currently recommended. Also, has Firebird 2.0 introduced
anything new to consider on this topic?
>
> Thanks in advance...
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
--------------------~--> Everything you need is one click away. Make
Yahoo! your home page now.
> http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/67folB/TM
> --------------------------------------------------------------------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>