Subject | Re: decimal / numeric |
---|---|
Author | csswa |
Post date | 2002-04-09T07:32:49Z |
The distinction is something to do with numerics storing the exact
precision/scale and decimals storing *at least* that precision/scale.
(I may have that back to front. No manual within reach right now.)
Can anyone give a practical example of the difference? Cheers.
Regards,
Andrew Ferguson
precision/scale and decimals storing *at least* that precision/scale.
(I may have that back to front. No manual within reach right now.)
Can anyone give a practical example of the difference? Cheers.
Regards,
Andrew Ferguson
--- In ib-support@y..., "Claudio Valderrama C." <cvalde@u...> wrote:
> "Peter Faulks" <pfaulks@c...> wrote in message
> news:20020409160536.4c287aa3.peter@p...
> > G'day
> >
> > Are there any differences at all between a decimal and numeric
type?
>
> In the SQL standard, yes.
> In the engine, no.
>
> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com -
http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase® WebRing