Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 07DEEFCDEAC for ; Mon, 30 Jan 2012 02:43:07 -0400 (AST) Received: from nm30-vm0.bullet.mail.ne1.yahoo.com ([98.138.91.69]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1RrkxG-0007X9-AJ for pgsql-sql@postgresql.org; Mon, 30 Jan 2012 06:43:07 +0000 Received: from [98.138.90.57] by nm30.bullet.mail.ne1.yahoo.com with NNFMP; 30 Jan 2012 06:42:52 -0000 Received: from [98.138.87.7] by tm10.bullet.mail.ne1.yahoo.com with NNFMP; 30 Jan 2012 06:42:52 -0000 Received: from [127.0.0.1] by omp1007.mail.ne1.yahoo.com with NNFMP; 30 Jan 2012 06:42:52 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 92047.34555.bm@omp1007.mail.ne1.yahoo.com Received: (qmail 78236 invoked by uid 60001); 30 Jan 2012 06:42:52 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1327905772; bh=qkuYUtJ/PrtNG2n5K7Co0Bw84dLJQH4gcMVmVqo+HXg=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=sGAXphf8pvsdYSvTaOilJjGKNzPKkNxT5g0lITKiMyc5pnJquZUbVnxn5Hf+nmxhwMSmr+/fljeMTWN8MuT2JIoyeAaqgQ+xeEkzhIwIVPCyfeTM2fTegLo8CIcaMN1dqWoyjh7ahSyrwrDlGvN8vYH9JS9V55CjATcMe07Hodw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=ThLjigkg8evn+4evSNRO3yn+exDVxev67c7a4oWktcceAtPpMwVSHNYimpPx/LNffjJEiTmPTPDRAHjHHOKrdgktnRK9rSbDpnM+vna3Jc7H0rvdYcBUdGuO/8d4DQnyQui0prqXUaq5VbJ5da83Izk1jrJzVgitk68z1OOqnBY=; X-YMail-OSG: 0kpmV3sVM1k_SO7cT5xIGtALYTNopSxIOvITkmrd38VMSo1 lLD9..gzn66WugE3xZHX17QIAfH.15d1iZrVS2lkngmFy.tilMQx_N7igUpO VeKT4mKKxB_V2d.H6YYy0CIgqGNIAWN7bmRX4Zvn7.298GuEgFR7qH6j4dU_ qn.gQ8bfeiYVIJzGNRYUdLQDW4oofKiG8mZCSx8QegKvjdn0aspwjiXXvC_1 KUt9SDg1qRR2P3l5iGTnatzlHYvTzOUPni.NRJXHugvOUyAyWCTvpKB3hIPp pwS_ZkOoPKYuYfb5LwbLcw2_N5r25XuEooWc.sPSjTGs4ehyecY2KLqhowfP fezAph2rZ7N7BTaxh0ltUJ.i8aSIK6gyLxa.Y3o82JjPfoRbQ4mARIh_rxc0 jjPSsogGxj5FOg.rgEiVvkLKS6iii5nBgXyzwwojz_nx8.z1nMfyc80hq_1c - Received: from [180.178.172.64] by web121606.mail.ne1.yahoo.com via HTTP; Sun, 29 Jan 2012 22:42:51 PST X-Mailer: YahooMailWebService/0.8.116.331537 Message-ID: <1327905771.73991.YahooMailNeo@web121606.mail.ne1.yahoo.com> Date: Sun, 29 Jan 2012 22:42:51 -0800 (PST) From: Rehan Saleem Reply-To: Rehan Saleem Subject: MS-SQL Store Procedure to Postgresql Function To: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1458340343-2142585322-1327905771=:73991" X-Pg-Spam-Score: 0.9 (/) X-Archive-Number: 201201/110 X-Sequence-Number: 36281 --1458340343-2142585322-1327905771=:73991 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable hi , how i can convert this store procedure to=A0PostgreSQL=A0function,=A0e= specially=A0I=A0really dont know how to set type to=A0readonly=A0in=A0Postg= reSQL.=0Athanks=0A=0A=0AALTERPROCEDURE [dbo].[sp_DeleteUserData]=0A=A0=A0= =A0=A0=A0 @ACDetailsID dbo.ACdetailsID_type READONLY=0A=A0=A0=A0=A0=A0 =0AA= S=0A=A0=0ADECLARE@ID int=0Abegintry=0Abegintransaction=0A=A0=0A=A0DECLARE c= _ACDetailsID CURSOR FOR SELECT id FROM @ACDetailsID=0A=A0OPEN c_ACDetailsID= =0A=A0FETCH NEXT FROM c_ACDetailsID INTO @ID=0A=A0WHILE (@@FETCH_STATUS =3D= 0) BEGIN=0A=A0=0A=A0=A0=A0=A0=A0 delete from UserAccountDetails=A0 where U= serDataAcountId=3D@ID =0A=A0=A0=A0=A0=A0 delete from UserAC where UserDataA= countId=3D@ID =0A=A0=A0=A0=A0=A0 =0A=A0FETCH NEXT FROM c_ACDetailsID INTO @= ID=0AEnd--end of while loop=A0=A0=A0=A0=A0=A0 =0A=A0=0Acommittransaction=A0= =A0=A0=A0=A0 =0ACLOSEc_ACDetailsID=0ADEALLOCATEc_ACDetailsID=0Aendtry=0A=A0= =0Abegincatch=0A=A0=A0=A0=A0=A0 rollback transaction;=0A=A0=A0=A0=A0=A0 pri= nt error_message( --1458340343-2142585322-1327905771=:73991 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
hi , how i can convert this store procedure t= o PostgreSQL function, especially I really dont kn= ow how to set type to readonly in PostgreSQL.
thanks


ALTER= PROCEDURE [dbo].[sp_DeleteUserData]=0A=0A
      @ACDetailsID dbo.ACdetailsID_type=0AREADONLY=
=0A=0A
     
=0A=0A
AS
=0A=0A
DECLARE @ID int
=0A=0A
begin try
=0A=0A
begin transaction
=0A=0A
 
=0A=0A
 = DECLARE c_ACDetailsID=0ACURSOR = FOR SELE= CT id FROM @ACDetailsID
=0A=0A
 OPEN c_ACD= etailsID
=0A=0A
 F= ETCH NEXT FROM c_ACDetailsID=0AINTO @ID
=0A=0A
 WH= ILE (@@FETCH_STATUS =3D 0) BEGIN=
=0A=0A
 
= =0A=0A
      delete from=0AUserAccountDetails  = where UserDataAcountId=3D@ID=0A
=0A=0A
  &nb= sp;   delete from=0AUserAC where UserDataAcountId=3D@ID =
=0A=0A
     
= =0A=0A
 FETCH NEXT FROM c_ACDetails= ID=0AINTO @ID
= =0A=0A
End --end of while loop  = ;    
=0A=0A
commit transaction      =0A=0A
CLOSE<= /span> c_ACDetailsID
=0A=0A
DEALLOCATE= c_ACDetailsID
=0A=0A
end try
=0A=0A
 
=0A=0A
begin catch
=0A=0A
      rollback transaction;
=0A=0A
  &= nbsp;   print error_message(
--1458340343-2142585322-1327905771=:73991--