Re: rule problem

There is only one thing I cannotprotect myself from is my own stupidity !
Tx very much to remind me that

:-))))))

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Jan Wieck" <janwieck(at)yahoo(dot)com>
To: <tsmets(at)brutele(dot)be>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: 25 March, 2002 7:48 PM
Subject: Re: [GENERAL] rule problem

> tsmets(at)brutele(dot)be wrote:
> >
> > [...]
> >
> > I thought I could do smthg like :
> > do instead
> > begin work
> > Action_1;
> > Action_2;
> > Action_3;
> > commit work
> >
> > Could some one suggest a better solution ?
> > I have never seen what happens if I set multiple rules.
> > Are they applied in the order they were created ?
>
> You cannot and don't need to do BEGIN and COMMIT as rule
> actions. Write it as
>
> do instead
> (
> Action_1;
> Action_2;
> Action_3;
> );
>
> and the actions will be perfomed in that order, all in one
> and the same transaction.
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck(at)Yahoo(dot)com #
>
>
>
>
> _________________________________________________________
>
> Do You Yahoo!?
>
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
>