Kent,
I suggest you read:
http://www.postgresql.org/docs/7.3/interactive/plpgsql-trigger.html
I found it very useful myself, and it should answer (almost?) all your
questions.
Note that you will need to add either pl/pgsql or pl/TCL to your
database to do triggers.
The docs. for both langu
Hello,
I'm trying to write a trigger that upon inserting a value in a table
another table is decremented. Something that could be used in an
inventory system, for example. I know it can be done easily outside
POSTGRES with PHP but in this case I would like the database to handle
it.
Example:
cre
