Обсуждение: Re: Multiple SQL statements within a function...

Поиск
Список
Период
Сортировка

Re: Multiple SQL statements within a function...

От
Ludwig Lim
Дата:
>
> --- 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