i'm currently faced with Oracle. I made some test table, what i want
next would be a trigger on insert, that searches for the MAX(NR) value
in my table, adds 1 and takes this as the NR of the insert that i just
did. I don't really know about the internals of triggers (sorry again),
but i'm quite willing to find out (will test with postgres at home).
All i found out yet, is that it should look something like this:
CREATE TRIGGER "TEST_DB".blah
AFTER INSERT ON "TEST_DB"."mydb";
/* maybe this should be changed to BEFORE INSERT, but i don't really
understand how it works */
DECLARE i integer;
BEGIN
select MAX(NR) into i from TEST_DB.mydb;
/* so here's what i think it should be like */
/* NR is the name of the field in my table, that */
/* should get the incremented value */
NR = i + 1;
END;
This doesn't work (of course). But the documentation won't really tell
me how to do it, or i'm just too stupid too understand all about
triggers.
