Re: A PL/PgSQL Question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>, PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: A PL/PgSQL Question
Date: 2002-12-13 19:41:36
Message-ID: 200212131141.36957.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-12-13 20:56:31 Re: UPDATE comparing dates and non-dates data
Previous Message Jie Liang 2002-12-13 18:33:16 Re: server terminated by a query in 7.3