what is the keyWord DELETING

[gauravgmbhr]

hi friends
I have been doing testing on an existing project
The tables in postgresQl Db has some trigger function using keyword 'DELETING'

IF DELETING THEN
          SOME SELECT STATEMENT
END IF;

can anyone please help me what is this keyword deleting
it is creating errors on insert (coz the trigger is on insert)

Is it really a keyword or its a mistake by the programmer who coded this
Plz help me

[michaelb]

You did not post the entire code, but this statement alone does not look valid.

You can review Postgres docs for more information:
Triggers
Create Trigger
Trigger Procedures

[masdi2t]

hi friends
I have been doing testing on an existing project
The tables in postgresQl Db has some trigger function using keyword 'DELETING'

IF DELETING THEN
          SOME SELECT STATEMENT
END IF;

can anyone please help me what is this keyword deleting
it is creating errors on insert (coz the trigger is on insert)

Is it really a keyword or its a mistake by the programmer who coded this
Plz help me

try this

IF (TG_OP = 'INSERT') THEN
SOME SELECT STATEMENT
ELSEIF (TG_OP = 'UPDATE') THEN
SOME SELECT STATEMENT
ELSEIF (TG_OP = 'DELETE') THEN
SOME SELECT STATEMENT
END IF;

[gauravgmbhr]

try this

IF (TG_OP = 'INSERT') THEN
SOME SELECT STATEMENT
ELSEIF (TG_OP = 'UPDATE') THEN
SOME SELECT STATEMENT
ELSEIF (TG_OP = 'DELETE') THEN
SOME SELECT STATEMENT
END IF;

WELL THANX for your valuable help
I worked it out