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

Reply via email to