| From: | Thirumoorthy Bhuvneswari <tbhuvneswari(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Doubt on opaque returntype!! |
| Date: | 2002-09-18 11:01:51 |
| Message-ID: | 20020918110151.73287.qmail@web13607.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hi,
I am using postgresql-7.0 with RedHat Linux-7.1. I am
having two tables:tableA and tableB. On every insert
in tableA there should be an update in tableB.
I created a function like the following:
CREATE FUNCTION test_trigger() RETURNS opaque As '
DECLARE
v_sno INT:=0;
BEGIN
FOR C1 IN select sno from tableB LOOP
v_sno:=v_sno+c1.sno;
update tableB set sno=v_sno;
END LOOP;
RETURN opaque;
END;
'LANGUAGE 'plpgsql';
This function is created. After that I created a
trigger as the following:
createm trigger test_trigger_1 after insert on tableA
for each row execute procedure test_trigger();
This trigger is also created. But, when I try to
insert into the tableA it comes with the error:
'ERROR during compile of test_trigger near line 8
ERROR:return type mismatch in function returning table
row at or near "opaque"
I don't know where I am wrong. please help me.
thanks.
bhuvaneswari.t
__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2002-09-18 12:32:57 | Re: Doubt on opaque returntype!! |
| Previous Message | Wim | 2002-09-18 08:36:53 | Re: [GENERAL] Still big problems with pg_dump! |