On Mar 11, 2011, at 10:38 AM, siva kiran balijepalli wrote:
> If there is no difference between functions and stored procedures, my doubt i show does the server know whether we are writing a function or stored procedure. As per my knowledge in oracle a function must return a value where as stored procedure cannot. IS this also true in postgresql. If yes how can we acheive it?
As I have already mentioned, PG Only Support Functions and whatever you want to implement/acheive you can do with Functions too.
About returning novalue from Function, you can write a function which will not return any value (return VOID).
Following is an link which you can use for information on Functions.
Thanks & Regards,
The Enterprise PostgreSQL Company
In response to
pgsql-novice by date
|Next:||From: Dem Fra Hedehusene i Danmark||Date: 2011-03-11 09:13:51|
|Subject: PIT Recovery of only certain database in the "cluster" ?|
|Previous:||From: Thomas Kellerer||Date: 2011-03-11 08:30:30|
|Subject: Re: regarding functions and storedprocedures|