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@yahoo.com>
To: <tsmets@brutele.be>
Cc: <pgsql-general@postgresql.org>
Sent: 25 March, 2002 7:48 PM
Subject: Re: [GENERAL] rule problem
> tsmets@brutele.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@Yahoo.com #
>
>
>
>
> _________________________________________________________
>
> Do You Yahoo!?
>
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
>
