Re: commit/rollback in postgre 8.2

[Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxx>]

IPS wrote:
>  Is it possible to use begin, commit and rollback commands within a 
> transaction block in  SQL function in postgre ver 8.2
>  
> with regards,
>
> I.P.S. Sethi
>  
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.


With Regards
Ashish Karalkar
EnterpriseDB

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general