Multiple SQL statements within a function...

Поиск
Список
Период
Сортировка
От Marc Mitchell
Тема Multiple SQL statements within a function...
Дата
Msg-id 00e101c238cf$d03dec20$3c0aa8c0@nmtransfer.com
обсуждение исходный текст
Ответ на --enable-locale  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
Ответы Re: Multiple SQL statements within a function...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: --enable-locale
Следующее
От: Tim Ellis
Дата:
Сообщение: tedia2sql 1.2.2 Released