From: | "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: MS-SQL Store Procedure to Postgresql Function |
Date: | 2012-02-02 21:00:45 |
Message-ID: | 4F2AF97D.50602@club-internet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 *************************
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2012-02-02 21:20:17 | Re: MS-SQL Store Procedure to Postgresql Function |
Previous Message | tiplip | 2012-02-02 07:58:35 | Re: Multiple tables query on Mapserver |