On 28 Nov 2006 at 8:45, kenp wrote: > SELECT INTO > "pCentreGroupPolicyID"
Don't you need to declare pCentreGroupPolicyID first? - .....etc.... $body$ declare pCentreGroupPolicyID bigint; begin ......etc.... This would cause the function not to run......what error message did you get? --Ray. ---------------------------------------------------------------------- Raymond O'Donnell Director of Music, Galway Cathedral, Galway, Ireland [EMAIL PROTECTED] ---------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq