Postgres Pro
Downloads
Home   >   mailing lists

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

From Vibhor Kumar
Subject Re: difference between functions and stored procedure
Date
Msg-id 9A20BED9-7C15-4E80-9C26-D7F0AD4A4249@enterprisedb.com
Whole thread Raw
In response to difference between functions and stored procedure  (siva kiran balijepalli <b.sivakiran@gmail.com>)
List pgsql-novice
Tree view 
On Mar 10, 2011, at 2:45 PM, siva kiran balijepalli wrote:

> 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???
>


Functions and Procedure are same in PostgreSQL. PG doesn't support CREATE PROCEDURE syntax.

Whatever you want to acheive you can acheive using Function. Do you have any specific requirement?

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-novice by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: regarding oid(object id)
Next
From: Majid Azimi
Date:
Subject: Job Scheduling