Re: Using a function to delete rows

I think you need to set the input parameter equal to a declared variable

The input variable is referenced via

DECLARE

your_int4_paramter ALIAS FOR $1;

Begin
Delete from clientinfo where caseid = your_int4_parameter;

-----Original Message-----
From: Derrick Betts [mailto:Derrick(at)grifflink(dot)com]
Sent: Thursday, October 09, 2003 12:25 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Using a function to delete rows

How do I create a function that takes as input (int4) and then deletes rows
from several tables. This is what I have tried, but I can't get it to
execute:

CREATE OR REPLACE FUNCTION public.deleteclient(int4)
RETURNS Void AS
'
BEGIN
Delete from clientinfo where caseid = $1;
Delete from caseinfo where caseid = $1;
Delete from tracking where caseid = $1;
Delete from casenotes where caseid = $1;
Delete from creditinfo where caseid = $1;
Delete from debts where caseid = $1;
Delete from education where caseid = $1;
Delete from employer where caseid = $1;
Delete from family where caseid = $1;
Delete from formeremployer where caseid = $1;
Delete from income where caseid = $1;
Delete from other where caseid = $1;
Delete from specialinterests where caseid = $1;
Delete from tracking where caseid = $1;
END'
LANGUAGE 'plpgsql' VOLATILE;

Thanks,
Derrick