Re: difference between functions and stored procedure - Mailing list pgsql-novice

From Chetan Suttraway
Subject Re: difference between functions and stored procedure
Date
Msg-id AANLkTi=gw_Kcxr-roxXacq-VFPEn2WFm5w__sL2mH91H@mail.gmail.com
Whole thread Raw
In response to difference between functions and stored procedure  (siva kiran balijepalli <b.sivakiran@gmail.com>)
List pgsql-novice


On Thu, Mar 10, 2011 at 2:45 PM, siva kiran balijepalli <b.sivakiran@gmail.com> wrote:
Hi all,
 
Can any one of u please tell me the diunction and a stored procedure??
In postgresql there is no command like "create or replace procedure"??
we haev to use "create function " for creating the procedures.. so how doest the server differentaites between those two???
 
please reply me...
 
 
regards
sivakiran.B

Please go through the below links:

http://archives.postgresql.org/pgsql-admin/2000-10/msg00123.php
http://www.postgresonline.com/journal/archives/15-Stored-Procedures-in-PostgreSQL.html
http://postgresqldbnews.blogspot.com/2007/09/creating-procedure-in-postgresql-using.html


--
Chetan Sutrave
Senior Software Engineer
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Phone: +91.20.30589523

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.

pgsql-novice by date:

Previous
From: siva kiran balijepalli
Date:
Subject: difference between functions and stored procedure
Next
From: Chetan Suttraway
Date:
Subject: Re: regarding oid(object id)