Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Thomas Hallgren
Oleg Bartunov wrote: On Sun, 20 Mar 2005, Joshua D. Drake wrote: 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 ? Here are a couple of GGIYF references:

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Tom Lane
Oleg Bartunov writes: > Hmm, the only real difference I see - is that SP are precompiled. > I think we should clearly outline what is SP and what is UDF and do we > are working on SP or just improving and extending our functions. AFAIR, the only person who's actually stated any intention to work

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Oleg Bartunov
On Sun, 20 Mar 2005, Joshua D. Drake wrote: 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 ? Here are a couple of GGIYF references: http://builder.com.c

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Joshua D. Drake
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 ? Here are a couple of GGIYF references: http://builder.com.com/5100-6388-1045463.html http://blogs.pingp

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Oleg Bartunov
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 proc

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Joshua D. Drake
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 t

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Oleg Bartunov
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

Re: [GENERAL] question about 8.1 and stored procedures

2005-03-20 Thread Bruce Momjian
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 hav