DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=JkAfmjBxamPHw8B58MVNf5YEaqcRICh6hvEaCz4GC9ua33MTvcZYCOpWDu7njugMoA
	cqTzNeM82fMa9K1LR7ywZglyJ/CgVPN2ssQSGpVsA0ifhbAFbcfXu3z2uu9HVFstTPYJ
	mTG9J6497FLoDqFtnIqtjavL9qsPph/R4MgAw=
Message-ID: <d8e7a1e30809150955v32f01897wa900261ac86af34b@mail.gmail.com>
Date: Mon, 15 Sep 2008 22:25:38 +0530
From: "c k" <shreeseva.learning@gmail.com>
To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Subject: Functions
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_13834_27070978.1221497738059"

------=_Part_13834_27070978.1221497738059
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Dear PG members,I want to know that does begin and end in plpgsql are
related to begin transactions and commit? if yes/no how? If I start to
execute a function of multiple statements does PG commits each transaction
within a function, or whole function as a transaction.
Also if first statement makes inserts/updates a row, does it automatically
available to that particular function execution only or to any other
instances of same function?
Please give the details.

In my system, function are extensively used and cab called by different
clients as ODBC, JDBC and others.

Thanks for help,

CPK

------=_Part_13834_27070978.1221497738059
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Dear PG members,<div>I want to know that does begin and end in plpgsql are related to begin transactions and commit? if yes/no how? If I start to execute a function of multiple statements does PG commits each transaction within a function, or whole function as a transaction.&nbsp;</div>
<div>Also if first statement makes inserts/updates a row, does it automatically available to that particular function execution only or to any other instances of same function?</div><div>Please give the details.</div><div>
<br></div><div>In my system, function are extensively used and cab called by different clients as ODBC, JDBC and others.</div><div><br></div><div>Thanks for help,</div><div><br></div><div>CPK</div></div>

------=_Part_13834_27070978.1221497738059--