Re: MS-SQL Store Procedure to Postgresql Function

Actullay there is no transaction support in internal PG routines.
So the code you posted is not translatable in PG PL/SQL because it
involve a transaction inside the process.

A +

Le 30/01/2012 07:42, Rehan Saleem a écrit :
> hi , how i can convert this store procedure to PostgreSQL function,
> especially I really dont know how to set type to readonly in PostgreSQL.
> thanks
>
>
> ALTERPROCEDURE [dbo].[sp_DeleteUserData]
> @ACDetailsID dbo.ACdetailsID_type READONLY
> AS
> DECLARE(at)ID int
> begintry
> begintransaction
> DECLARE c_ACDetailsID CURSOR FOR SELECT id FROM @ACDetailsID
> OPEN c_ACDetailsID
> FETCH NEXT FROM c_ACDetailsID INTO @ID
> WHILE (@@FETCH_STATUS = 0) BEGIN
> delete from UserAccountDetails where UserDataAcountId=(at)ID
> delete from UserAC where UserDataAcountId=(at)ID
> FETCH NEXT FROM c_ACDetailsID INTO @ID
> End--end of while loop
> committransaction
> CLOSEc_ACDetailsID
> DEALLOCATEc_ACDetailsID
> endtry
> begincatch
> rollback transaction;
> print error_message(

--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************