I'm a little fuzzy on this, and I've been unable to find docs that clear
it up for me. A pointer to a helpful doc would be just as welcome as an
outright explanation ;)
Let's take the following fictional scenerio:
BEGIN;
INSERT INTO table1 VALUES ('somestring');
INSERT INTO table1 VALUES ('anotherstring');
SELECT user_defined_function();
COMMIT;
In this case, user_defined_function() does a lot more table manipulation.
I don't want that to be done if any statement prior fails, but it seems as
if it's always done, regardless. It seems as if the second INSERT is not
executed if the first fails, but the function is always called.
So ... I'm a little fuzzy on this. Is there a doc that details this
behaviour?
TIA.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com