On 2006-01-19, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
> On Tue, Jan 17, 2006 at 09:55:42PM -0700, Assad Jarrahian wrote:
>> q2) How does one get access to the rows just selected in the CREATE
>> RULE computation?
>
> Via NEW and OLD. Read Chapter 34 of the documentation.

He's talking about a SELECT rule. A SELECT rule is no more and no less than
a view - you can do nothing with select rules that you can't do with a
normal view.

(You can only have one SELECT rule, it must be named _RETURN, and it must
be a DO INSTEAD SELECT rule. If you put such a rule on a plain table, you
will find that the table changes into a view.)

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services