Re: Data visibility

Rafal Pietrak <rafal@zorro.isa-geek.com> writes:
> Hmm. I tried that, But I'm stuck with finding a way to propagate the
> 'intermediate data' between BEFORE/AFTER triggers, *outside* of a TABLE
> structure. That data is easily accesable inside the BEFORE TRIGGER as
> simple variable.

Um ... what data do you think is visible to the BEFORE trigger but not
the AFTER trigger?  They both see both states of the row, if that's what
you're wondering.

            regards, tom lane