Re: plpgsql: UPDATE...Returning in FOR loop

On 02/03/2009 20:19, Tom Lane wrote:

> Well, that has nothing to do with UPDATE RETURNING; it's apparently
> failing here:
>
>> rec recipients;
>
> I suppose "recipients" is a composite type one of whose columns is of a
> NOT NULL domain. Best advice is "don't do that" --- not-null domains

Thanks Tom and Sam for your replies - I hadn't absorbed the bit in the
docs about variables being initialised to NULL in the absence of
anything else.... removing NOT NULL from message_type_domain did the
trick, and all works as I hoped.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------