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

Re: rule problem

From: <tsmets(at)brutele(dot)be>
To: "Jan Wieck" <janwieck(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: rule problem
Date: 2002-03-25 21:43:07
Message-ID: 003801c1d446$28163db0$6501a8c0@calvin (view raw or flat)
Thread:
Lists: pgsql-general
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
> 
> 
> 
> 



In response to

pgsql-general by date

Next:From: Jeroen T. VermeulenDate: 2002-03-26 00:24:02
Subject: libpqxx has HTML docs
Previous:From: Jan WieckDate: 2002-03-25 21:20:04
Subject: Re: accessing fully qualified fields in records in PLPGSQL?

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