I'm trying to figure out how to do in Postgres what I already pretty well understand in DB2: Create a stored procedure that accepts a couple of arguments, does a look-up in a table using those args in a where clause, and then return a boolean result of whether a matching row was found. Or potentially return a row. I have a few questions: 1) Is PL/Tcl the only way to do stored procedures? 2) Is CREATE FUNCTION pretty much a logical equivalent to CREATE PROCEDURE in other RDBMSs? Is it considered part of the SQL command set to Postgres? 3) Am I right in guessing that it would be a very big job to support Java under CREATE LANGUAGE? 4) How about granting rights to stored procedures? In DB2 one can grant privileges to what are called packages. Well, a stored proc is like a package. One can grant privileges to a stored proc to have access to a table or view and what it can do on that table and view. Then in DB2 one can grant access for a group or user to invoke a stored proc. I don't see where the Postgres GRANT can do that: http://postgresql.nextpath.com/docs/user/sql-grant.htm A) So is there a way to assign access privileges to a stored proc (ie function) that are independent of the user who is calling it? B) And can one do grants on which users can actually call a particular function?
