Re: Multiple SQL statements within a function...
Re: Multiple SQL statements within a function...
От:
Ludwig Lim <lud_nowhere_man@yahoo.com>
Дата:
> > --- Marc Mitchell 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