After update complete set

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: After update complete set
Date: 2004-05-13 18:22:35
Message-ID: 40A3BCEB.60308@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

Is there a way in pg to fire a function when a complete (not row by row)
set is updated/inserted/deleted, for instance.

update order_detail set confirmed='S' where modifieddate=current_date;

Then after all the affected rows are updated, I need some code to
uptaded other tables from the information of the updated rows in the
details table.

Thanks in advance.

--
Sinceramente,
Josué Maldonado.

"Cuando los ricos se hacen la guerra, son los pobres los que mueren."
Jean Paul Sartre. Filósofo y escritor francés.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anony Mous 2004-05-13 18:56:48 setting local time without restarting server
Previous Message Sally Sally 2004-05-13 17:37:33 DBI remote connection problem