X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D331F9DC80C for ; Tue, 27 Dec 2005 09:57:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89966-10 for ; Tue, 27 Dec 2005 09:57:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lerami.lerctr.org (lerami.lerctr.org [192.147.25.11]) by postgresql.org (Postfix) with ESMTP id B79289DC804 for ; Tue, 27 Dec 2005 09:57:48 -0400 (AST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lerami; d=lerctr.org; b=YjObQ7bYxkulRn3ZkpbSoQI1aFRDuIGwgTYuvkQ9eH4URj4QZ5/6Af2Sw7d5jEQmia8h8qqVlOlDKwZPcFfRdC13saFhHK8SnIzTcW4Y2ulq0HJks50CGbOl2lPwCEmgDOk48Tj7WESmIzuaKtpRGSd882b206dHW4LFD0R6ouU=; Received: from prayer by lerami.lerctr.org with local (Exim 4.60) (envelope-from ) id 1ErFKq-00002v-2Y; Tue, 27 Dec 2005 07:57:52 -0600 From: Larry Rosenman To: Murugan G Cc: pgsql-admin@postgresql.org Reply-To: Larry.Rosenman@pervasive.com Subject: Re: Procedure in PostgresQL Date: 27 Dec 2005 07:57:51 -0600 X-Mailer: Prayer v1.0.8 X-Originating-IP: [64.132.13.2] Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Message-Id: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/321 X-Sequence-Number: 20041 On Dec 27 2005, Murugan G wrote: > Hello, > Is there any way to create procedure in postgresQL. Yes, look at the docs on PL/pgSQL and the other PL's: http://www.postgresql.org/docs/current/static/plpgsql-control-structures.ht= ml#PLPGSQL-CONDITIONALS http://www.postgresql.org/docs/current/static/plpgsql.html >=20 > Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=20 > Sobha Renaissance Information Technology Private Limited An SEI-CMM &=20 > P-CMM Level 5 Company World's 1st SSE-CMM Level 5 Company BS 7799=20 > certified by British Standards Institute ISO 9001:2000 Certified by T=C3= =9CV=20 > Rheinland/Berlin-Brandenburg A Six Sigma Practice Company Tel: + 91 80=20 > 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80 51252222 Email > : murugan.g@renaissance-it.com; Web: www.renaissance-it.com=20 > =20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=20 > The information transmitted is intended only for the person or entity to= =20 > which it is addressed and may contain confidential and/or privileged=20 > material. Any review, retransmission, dissemination or other use of, or= =20 > taking of any action in reliance upon, this information by persons or=20 > entities other than the intended recipient is prohibited. If you received= =20 > this in error, please contact the sender and delete all copies from any= =20 > computer. >=20 >=20 >=20 -- Larry Rosenman, Database Support Engineer, E-Mail:=20 Larry.Rosenman@pervasive.com Pervasive Software, 12365B Riata Trace=20 Parkway, Austin, TX 78727 Office: 512-231-6173