From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
---|---|
To: | siva kiran balijepalli <b(dot)sivakiran(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: regarding functions and storedprocedures |
Date: | 2011-03-11 08:39:09 |
Message-ID: | 6FA066B2-696C-4B19-889B-465912ED4A04@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
http://www.postgresql.org/docs/current/static/sql-createfunction.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dem Fra Hedehusene i Danmark | 2011-03-11 09:13:51 | PIT Recovery of only certain database in the "cluster" ? |
Previous Message | Thomas Kellerer | 2011-03-11 08:30:30 | Re: regarding functions and storedprocedures |