On 2/14/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Wed, Feb 14, 2007 at 05:18:10PM -0500, Walter Vaughan wrote:
> This may not help, but I noticed using pgAdminIII, you can create a
> procedure or a function, but they seem to have the same creation interface
> and use the same icon.
Way back when I learned that procedures are merely functions that don't
return a value. So in that sense procedures are indeed just functions.
You obviously mean something else but I'm not sure what.
I thought stored procedures did not run implicitly in transactions
like functions do. If that's the case, that's a huge
difference....you could do vacuum, large loads, etc. that you
currently have to do outside the database. I'm not sure about this
though.
merlin
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
