Skip site navigation (1) Skip section navigation (2)

Re: what are rules for?

From: "Michael Shulman" <shulman(at)mathcamp(dot)org>
To: "Dean Rasheed" <dean_rasheed(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us, kleptog(at)svana(dot)org, adam(dot)r(at)sbcglobal(dot)net
Subject: Re: what are rules for?
Date: 2008-06-26 15:29:30
Message-ID: c3f821000806260829u451797bfsdb7246a1b391929f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, Jun 26, 2008 at 5:08 AM, Dean Rasheed <dean_rasheed(at)hotmail(dot)com> wrote:
> The Oracle "instead of" trigger ducks this issue completely. The
> trigger is called once per row in the view that matches the top-level
> "where" clause, and it is entirely up to the author of the trigger
> function to work out what to update (if anything).

That sounds like exactly the sort of thing I was envisioning.
Although from what Tom said, it sounds as though "instead of" triggers
in PostgreSQL would have to be implemented in a significantly
different way from other triggers.

How does an Oracle "instead of" trigger decide how many rows to tell
the caller were updated?  Can this "return value" be modified
programmatically by the trigger?

Mike

In response to

Responses

pgsql-general by date

Next:From: Brandon MetcalfDate: 2008-06-26 15:32:26
Subject: new RETURNING clause and Pg.pm
Previous:From: Garry SaddingtonDate: 2008-06-26 15:27:06
Subject: Re: Unicode problem again

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group