Just be sure that if you use triggers, and you need to use temporary variables to hold results of in-between computations, use DOUBLE PRECISION for these temporary variables.

Joseph Alba
jalba313@...

"Ann W. Harrison" <aharrison@...> wrote:
bcteh_98 wrote:

>
>
> Hi,
>
> What is the difference between Decimal and numeric
> datatype ?

No. There should be, but Firebird doesn't enforce it. According the
the standard numeric (4,2) should have a range of values between -99.99
and +99.99 (4 digits of precision, two digits of scale) while decimal
(4,2) must accept at least that range and can accept an implementation
defined range. Firebird accepts larger numbers in both.

Regards,

Ann

>

---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.

[Non-text portions of this message have been removed]