Re: Syntax Issue in Trigger Function?? - Mailing list pgsql-general

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