Cheers for that! We did catch it eventually. My colleague was using
pgAdminIII and was apparently typing:
v_ref := ''/'';
and pgAdminIII "appears" to have been "helping out" by escaping the
On Tue, 28 Sep 2004 22:46:31 +0300, Andre Maasikas
> tsarevich(at)gmail(dot)com wrote:
> > In Postgres 7.3.5 -
> > When we try to insert a new record into our parties.party table which
> > is then meant to fire off a trigger to update a column in the table
> > with some de-normalised information, we get the following error:
> > ERROR: FLOATING POINT EXCEPTION! The last floating point operation
> > either exceeded the legal ranges or was a divide by zero.
> > Can someone help spot our syntax erorr, please?
> This looks to me like a candidate:
> > v_ref := \'\'/\'\';
> Without escaping it looks like v_ref := ''/'';
> dividing 2 empty strings, and indeed gives
> division by zero in psql. What dividing 2 strings is actually
> supposed to mean is not evident form the docs in the first glance.
> > v_ref := \'\'/\'\' || v_parent_party_id || v_ref;
> This one too.
In response to
pgsql-general by date
|Next:||From: Devrim GUNDUZ||Date: 2004-09-29 08:55:45|
|Subject: Re: About PostgreSQL's limit on arithmetic operations|
|Previous:||From: tsarevich||Date: 2004-09-29 08:34:58|
|Subject: Composite Type Argument Construction to a Function|