Re: [SQL] A PL/PgSQL Question

2002-12-13 Thread Josh Berkus
Ludwig, >What is the difference between the first and second > chunk PL/PgSQL INSERT/UPDATE trigger function code > aside from the fact that first scenario will result in > an "ABORT" state? > > Are there any instances where a NOTICE and a RETURN > NULL statement is a much better than a RA

[SQL] A PL/PgSQL Question

2002-12-13 Thread Ludwig Lim
Hi: I have the following PL/PgSQL code blocks: a) IF (condition) THEN RAISE EXCEPTION ''Cannot Insert''; END IF; b) IF (condition) THEN RAISE NOTICE ''Cannot Insert''; RETURN NULL; END IF; What is the difference between the first and second chunk PL/PgSQL INSERT/UPDA