Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3L1wN336840;
	Fri, 20 Apr 2001 21:58:23 -0400 (EDT)
	(envelope-from rmello@fslc.usu.edu)
Received: (from rmello@localhost)
	by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id
	f3L1wCFX024183; Fri, 20 Apr 2001 19:58:12 -0600
Date: Fri, 20 Apr 2001 19:58:12 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: Jie Liang <jliang@ipinc.com>
Cc: pgsql-sql@postgresql.org, pgsql-hacker@postgresql.org
Subject: Re: plpgsql
Message-ID: <20010420195812.A24166@cc.usu.edu>
References: <Pine.BSF.4.10.10104201646290.99410-100000@tidal.ipinc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.17i
In-Reply-To: <Pine.BSF.4.10.10104201646290.99410-100000@tidal.ipinc.com>;
	from jliang@ipinc.com on Fri, Apr 20, 2001 at 04:58:02PM -0700
X-Archive-Number: 200104/346
X-Sequence-Number: 2704

On Fri, Apr 20, 2001 at 04:58:02PM -0700, Jie Liang wrote:
> 
> I 've a question about begin...end in plpgsql
> does
> sql stmts in
> begin
> ....
> end;
> will go one transaction?

	Read the documentation (programmer's guide). It's all there. It's to
answer your questions that we take the time to write docs in the first
place :)
	Short answer: everything in your function is executed in one
transaction. BEGIN and END in PL/pgSQL are NOT the same as in the
transaction semantics.

	-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
If at first you don't succeed, destroy all evidence that you tried.