Re: numeric in plpgsql function
| From: | Martin Marques | Date: | Thu, 02 Oct 2003 12:30:53 +0000 |
| Subject: | Re: numeric in plpgsql function | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30803@lists.php.net to get a copy of this message | ||
El Mié 01 Oct 2003 22:45, Gezeala 'Eyah' "Bacuño" II escribió:
> Saw this in the Postgresql manual :
>
> Chapter 8. Data Types
>
> Some of the operators and functions (e.g., addition and multiplication)
> do not perform run-time error-checking in the interests of improving
> execution speed. On some systems, for example, the numeric operators for
> some data types may silently cause underflow or overflow.
> is this a bug or what??
If it's documented, then it's a feature.
As you see, it's to gain speed. Remember that this is a database engine, not a
scientific aplication.
--
09:29:01 up 41 days, 1:11, 3 users, load average: 2.44, 1.83, 1.08
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------