Procedure : Many IN and/or Many OUT parameters and no return value. (CREATE DBPROC in MaxDB)
Function : only IN parameters but returns a value. (CREATE FUNCTION in MaxDB and PostgreSQL)
In this sense only, procedures does'nt exist in PostgreSQL, but since PostgreSQL 7.4, functions can returns VOID.
I thing that stored procedures are very usefull in MaxDB AND PostgreSQL and it's a very good thing that
functions are coming with MaxDB.
I'm working with PostgreSQL 7.4 at work and with SAP-DB 7.4 at home and stored procedures gime me power with this 2 products !
Damien.
Anhaus, Thomas a écrit:
Vinod Kumar Singh wrote :
Stored Procedures are available in PostgreSQL also and syntax is very
similar to Oracle. Stored Procedures in SAP DB are only for token
presence they does not give any power to developer, working with them is
a great pain.
Vinod
Hi Vinod,
I must contradict your statement that Stored Procedures are only for token presence.
We are working hard on improving Stored Procedures, Trigger and Functions, but
of course we depend on input about the experience of the users.
It therefore would be great if you could give me some examples, why working with Stored Procedures
is a pain.
Best Regards,
Thomas
-----Original Message----- From: news [mailto:[EMAIL PROTECTED] Behalf Of Vinod Kumar Singh Sent: Freitag, 16. Januar 2004 08:53 To: [EMAIL PROTECTED] Subject: Re: Functions of MaxDB
Stored Procedures are available in PostgreSQL also and syntax is very similar to Oracle. Stored Procedures in SAP DB are only for token presence they does not give any power to developer, working with them is a great pain.
Vinod
GUITARD Damien wrote:
Hi, Function are available in MaxDB (7.5) but not in actual SAP-DB (7.4). -> CREATE DBFUNCTION and soon CREATE FUNCTION (search CREATE DBFUNCTION in docs online) Procedures are available in MaxDB and SAP-DB (and not in PostgreSQL). -> CREATE DBPROC
Damien Toulouse (France) ;-)
[EMAIL PROTECTED] a écrit:
Hi everybody,
I want to switch from Oracle to MaxDB or PostgreSQL, but I must prepare a comparative document before chosing between the 2 of them.
Do you know where I could find such information ? In the MaxDB documentation, I can find the Oracle functions that are not available in MaxDB, but they don't give the equivalent !
Thank you for answering,
Léna Toulouse (France)
