Re: Encountering NULLS in plpgsql - Mailing list pgsql-general

From Richard Huxton
Subject Re: Encountering NULLS in plpgsql
Date
Msg-id 441AD5C7.40304@archonet.com
Whole thread Raw
In response to Encountering NULLS in plpgsql  (Randy Yates <yates@ieee.org>)
List pgsql-general
Randy Yates wrote:
> I wrote a simple pl to compute running sums, but when it encountered a
> null on a float4 value it caused pgadminIII to crash (exited
> abruptly). Is this intended behavior?

No, but we'll need more information to figure out what is going on.

What language did you use for the procedural code?
Can you show us that code?
What version of postgreSQL?
What version of pgAdmin III?
Was there any error message?
Is there anything in the logs?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: after insert trigger hangs
Next
From: Richard Huxton
Date:
Subject: Re: each line counter