Multiple SQL statements within a function...

From: "Marc Mitchell" <marcm(at)eisolution(dot)com>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Multiple SQL statements within a function...
Date: 2002-07-31 20:21:05
Message-ID: 00e101c238cf$d03dec20$3c0aa8c0@nmtransfer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)eisolution(dot)com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Ellis 2002-07-31 20:41:14 tedia2sql 1.2.2 Released
Previous Message Oliver Elphick 2002-07-31 19:33:19 Re: --enable-locale