Re: commit/rollback in postgre 8.2

On 09/03/2009 10:34, Ashish Karalkar wrote:
> IPS wrote:
>>  Is it possible to use begin, commit and rollback commands within a
>> transaction block in  SQL function in postgre ver 8.2
>
> I guess you can  use nested blocks in side a function(BEGIN,END) but not
> commit   because a SQL function  runs as a single transaction.

He could use SAVEPOINT to do something similar -

  http://www.postgresql.org/docs/8.2/static/sql-savepoint.html

- though it might or might not work for him, depending on his needs.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------