A PL/PgSQL Question

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/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 RAISE EXCEPTION
statement?

Thank you very much,

ludwig lim

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com