Multiple SQL statements within a function... - Mailing list pgsql-admin

From Marc Mitchell
Subject Multiple SQL statements within a function...
Date
Msg-id 00e101c238cf$d03dec20$3c0aa8c0@nmtransfer.com
Whole thread Raw
In response to --enable-locale  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
Responses Re: Multiple SQL statements within a function...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
If you have multiple SQL statements within a single SQL or PL/PGSQL
function, are they automatically treated as a single multi-statement
transaction or does this require you to put BEGIN/COMMIT statements within
your function which itself would require you to be cognoscente of the
transactional state of your current database session.

Am assume the MST is implicit but have been looking for answer in online
docs and have  been unable to confirm one way or the other.  Can anyone
sight a documentation reference?

Thanks,

Marc Mitchell
Enterprise Information Solutions, Inc.
marcm@eisolution.com



pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: --enable-locale
Next
From: Tim Ellis
Date:
Subject: tedia2sql 1.2.2 Released