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
single quotes.
On Tue, 28 Sep 2004 22:46:31 +0300, Andre Maasikas
<andre.maasikas@abs.ee> wrote:
> tsarevich@gmail.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.
>
> Andre
>