Re: A PL/PgSQL Question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: A PL/PgSQL Question
Date
Msg-id 200212131141.36957.josh@agliodbs.com
Whole thread Raw
In response to A PL/PgSQL Question  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
List pgsql-sql
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 RAISE EXCEPTION
> statement?

Not that I have encountered, but YMMV.

--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: Re: server terminated by a query in 7.3
Next
From: Josh Berkus
Date:
Subject: Re: UPDATE comparing dates and non-dates data