Re: Multiple SQL statements within a function...

>
> --- Marc Mitchell <marcm(at)eisolution(dot)com> wrote:
> Am assume the MST is implicit but have been
> lookingfor answer in onlinedocs and have been
> unable to confirm one way or the other. Can anyone
> sight a documentation reference?

>From the PostgreSQL 7.1.2 Manual section 23.2.
(Structure of PL/pgSQL)

"It is important not to confuse the use of BEGIN/END
for grouping statements in PL/pgSQL with the database
commands for transaction control. PL/pgSQL's BEGIN/END
are only for grouping; they do not start or end a
transaction. Functions and trigger procedures are
always executed within a transaction established by
an outer query --- they cannot start or commit
transactions, since PostgreSQL does not have nested
transactions. "

Hope that helps,

ludwig.

__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com