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
------------------------------------------------------------------