[SQL] plpgsql - how can I use TG_OP ?

[Andreas Schmitz]

Hello *,

I have a litlle problem writing a plpgsql trigger function. I am in need to 
get some interpretaion of the TG_OP within an IF clause to decide with action 
will be taken. I tried it that way:

         IF (TG_OP=DELETE AND check_count > 1) THEN

             UPDATE tipp_team
                SET team_count = (select count(*) from tipp_team_members
                                   where member_team_id=OLD.member_team_id)
                                   WHERE team_id=OLD.member_team_id;
         END IF;


and I got the following error:

tippspiel2003=# delete from tipp_team_members where member_team_id=2 and 
member_user_id=27;
WARNING:  Error occurred while executing PL/pgSQL function 
update_team_member_count
WARNING:  line 13 at if
ERROR:  Attribute "delete" not found
tippspiel2003=#


What am I making wrong ?


best regards

-Andreas Schmitz


-- 
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]