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

From Ludwig Lim
Subject Re: Multiple SQL statements within a function...
Date
Msg-id 20020801020331.47566.qmail@web40002.mail.yahoo.com
Whole thread Raw
In response to Multiple SQL statements within a function...  ("Marc Mitchell" <marcm@eisolution.com>)
List pgsql-admin
>
> --- Marc Mitchell <marcm@eisolution.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

pgsql-admin by date:

Previous
From: Tim Ellis
Date:
Subject: tedia2sql 1.2.2 Released
Next
From: Tom Lane
Date:
Subject: Re: Multiple SQL statements within a function...