Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com [216.136.173.59]) by postgresql.org (8.11.3/8.11.1) with SMTP id f66DGsa52289 for ; Fri, 6 Jul 2001 09:16:54 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Jul 2001 13:16:49 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f66DNaJ21413; Fri, 6 Jul 2001 09:23:36 -0400 From: Jan Wieck Message-Id: <200107061323.f66DNaJ21413@jupiter.us.greatbridge.com> Subject: Re: Transactions within a function In-Reply-To: <000a01c10618$ca7f0bb0$c901a8c0@automatic100> from =?ISO-8859-1?Q?Daniel_=C5kerud?= at "Jul 6, 2001 02:40:08 pm" To: =?ISO-8859-1?Q?Daniel_=C5kerud?= Date: Fri, 6 Jul 2001 09:23:36 -0400 (EDT) CC: PostgreSQL-general X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/161 X-Sequence-Number: 12076 Daniel Åkerud wrote: > Do the BEGIN and END in a function also indicate that it is done in a transaction? > Or can you put another BEGIN TRANSACTION; END TRANSACTION; in there? The BEGIN and END keywords in PL/pgSQL have absolutely no transactional meaning. They group statements into blocks with the possibility of named blocks using the <