On Sun, 20 Mar 2005, Joshua D. Drake wrote:
Oleg Bartunov wrote:
On Sun, 20 Mar 2005, Bruce Momjian wrote:
Tony Caduto wrote:
Hi,
I read in a article/interview on http://madpenguin.org/cms/html/62/3677.html
that work was being done on improving/adding support for sql standard
compliant stored procs/functions
Does anyone know exactly what that means?
Does it mean that Postgres will have stored procs that can have input and output params?
Yes.
I think that keyword here is 'sql standard compliant', not stored procedures
itself, because we have them for a long time and with support of dozen
languages. Or I miss something ?
What I read from this is, when will PostgreSQL have stored procedures like Oracle. Thus the IN/OUT parameter statement.
I mean original Josh's interview
"An example of what people are working on right now is SQL standard compliant stored procedures. We have procedures now, but they're not compliant with the standard syntax." Nothing about Oracle unless Oracle has standard compliant
stored procedures.
My understanding is that 8.1 will have a much more mature implementation of stored procedures versus UDFs (Which we have had forever).
What's the difference between UDF and stored procedure ?
Sincerely,
Joshua D. Drake
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
