logically-delete a row rather than actually remove in from table in postgreSQL

[Mitramirsa]

I want to write a trigger so that rows deleted from the table are logically-deleted, rather than being actually removed. That is, such rows are marked as being deleted, rather than actually being deleted from the table.

in sql server I know that we can use INSTEAD OF DELETE trigger but I don`t know how can I do the same action in PostgreSQL.

It needed to write a function that update the rows which asked for delete.

please help me with the trigger and related function which is needed .

[rski]

I want to write a trigger so that rows deleted from the table are logically-deleted, rather than being actually removed. That is, such rows are marked as being deleted, rather than actually being deleted from the table.

in sql server I know that we can use INSTEAD OF DELETE trigger but I don`t know how can I do the same action in PostgreSQL.

It needed to write a function that update the rows which asked for delete.

please help me with the trigger and related function which is needed .

In postgres u have rules (in which u can use instead) and u can use triggers 'after' which do some updates and return null.
Give more informations about u'r problem.

[Mitramirsa]

In postgres u have rules (in which u can use instead) and u can use triggers 'after' which do some updates and return null.
Give more informations about u'r problem.

Thanks for your help .
I want to write a trigger that acts like this:
When a user executes a DELETE statement, the trigger must set the WhenDeleted value to the system’s CURRENT_TIMESTAMP value, for each of the rows targeted by that DELETE statement.

[rski]

Thanks for your help .
I want to write a trigger that acts like this:
When a user executes a DELETE statement, the trigger must set the WhenDeleted value to the system’s CURRENT_TIMESTAMP value, for each of the rows targeted by that DELETE statement.

i don't see the trigger, so i write it

CREATE FUNCTION LogicalDeleteFunction ()
RETURNS TRIGGER
LANGUAGE plpgsql
AS $$
declare
t timestamp;
BEGIN
t=current_timestamp;
UPDATE patients
SET
patients.whendeleted = current_timestamp
JOIN deleted ON deleted.patientnum = patients.patientnum
??no where clause
what is deleted table??

return OLD;
END;
$$;

create trigger my_trig before delete on patients for each row execute procedure LogicalDeleteFunction ();