Using a function to delete rows

From: "Derrick Betts" <Derrick(at)grifflink(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Using a function to delete rows
Date: 2003-10-09 17:25:22
Message-ID: 005701c38e8a$52f7fa00$0100a8c0@BigOne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Slava Gorski 2003-10-09 17:29:03 get diagnostics not supported by ecpg?
Previous Message Oliver Fromme 2003-10-09 14:38:00 Problem with pg_user (somewhat urgent)