Обсуждение: Procedure in PostgresQL

Hello,
Is there any way to create procedure in postgresQL.

Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
===========================================================================
Sobha Renaissance Information Technology Private Limited
An SEI-CMM & P-CMM Level 5 Company
World's 1^st SSE-CMM Level 5 Company
BS 7799 certified by British Standards Institute
ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
A Six Sigma Practice Company
Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80 51252222
Email : murugan.g@renaissance-it.com; Web: www.renaissance-it.com
===========================================================================
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies from any computer.

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.html#PLPGSQL-CONDITIONALS
 http://www.postgresql.org/docs/current/static/plpgsql.html


>
> Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658
> ===========================================================================
> Sobha Renaissance Information Technology Private Limited An SEI-CMM &
> P-CMM Level 5 Company World's 1st SSE-CMM Level 5 Company BS 7799
> certified by British Standards Institute ISO 9001:2000 Certified by TÜV
> Rheinland/Berlin-Brandenburg A Six Sigma Practice Company Tel: + 91 80
> 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80 51252222 Email
> : murugan.g@renaissance-it.com; Web: www.renaissance-it.com
>
> ===========================================================================
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete all copies from any
> computer.
>
>
>

-- Larry Rosenman, Database Support Engineer, E-Mail:
Larry.Rosenman@pervasive.com Pervasive Software, 12365B Riata Trace
Parkway, Austin, TX 78727 Office: 512-231-6173