Hengky Lie wrote:
> Dear friends,
Hello. Quick tip - don't reply to another message when starting a new
thread, people will assume it's part of the old thread.
[snip most of query]
> / 100::numeric *
> Why the calculation result has so many decimals ?
Because you've cast 100 to numeric, rather than numeric(10,2) or
whatever. This means you get the full accuracy on the calculation - it
won't ever trim a numeric (that's the whole reason to have the type).
In response to
pgsql-sql by date
|Next:||From: Ruben Gouveia||Date: 2008-09-12 16:47:39|
|Subject: Re: DIfference between max() and greatest() ?|
|Previous:||From: Hengky Lie||Date: 2008-09-12 09:22:51|
|Subject: Pls Hlp: SQL Problem|