diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-06-25 01:32:02 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-06-25 01:32:02 +0000 |
| commit | 669111800fafbe548882b01b26cf73df3225f9fb (patch) | |
| tree | cffaaaeb17d69b19a513c744a2c2227eaa850b90 /src/backend/commands/dbcommands.c | |
| parent | f3dbacab0c033ab43b8a6378cdb1ee368018bcd2 (diff) | |
| download | postgresql-669111800fafbe548882b01b26cf73df3225f9fb.tar.gz postgresql-669111800fafbe548882b01b26cf73df3225f9fb.zip | |
Add item:
> * Add NUMERIC division operator that doesn't round?
>
> Currently NUMERIC _rounds_ the result to the specified precision.
> This means division can return a result that multiplied by the
> divisor is greater than the dividend, e.g. this returns a value > 10:
>
> SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6;
>
> The positive modulus result returned by NUMERICs might be considered
> inaccurate, in one sense.
>
Diffstat (limited to 'src/backend/commands/dbcommands.c')
0 files changed, 0 insertions, 0 deletions