Re: Multiple SQL statements within a function...

Поиск
Список
Период
Сортировка
От Ludwig Lim
Тема Re: Multiple SQL statements within a function...
Дата
Msg-id 20020801020331.47566.qmail@web40002.mail.yahoo.com
обсуждение исходный текст
Ответ на Multiple SQL statements within a function...  ("Marc Mitchell" <marcm@eisolution.com>)
Список 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 по дате отправления:

Предыдущее
От: Tim Ellis
Дата:
Сообщение: tedia2sql 1.2.2 Released
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Multiple SQL statements within a function...