PostgreSql Large Objects and Stored Functions

Unlike Oracle or Microsoft, Postgres does not differentiate between functions and stored procedures...it has only functions (look up in the postgres manual about functions...very flexible as well, you can call c or java libraries and other fun stuffs). So you'll create a function (probably in PLPGSQL) to accept a few parameters, then call the function using a select statement as function(arguement1,arg2,etc...). Here is an example if you want a template:

CREATE OR REPLACE FUNCTION deleteme
(deleteid integer)
RETURNS integer AS
$BODY$
BEGIN
delete from mytable_attrib where id = $1;
delete from mytable where id = $1;
return 0;
END;
$BODY$
LANGUAGE plpgsql VOLATILE;

Little different in it's language and syntax then you might be used to...do not name a variable the same name as a column name for example...or be prepared to shift to dynamic SQL to build a statement in a variable using plpgsql and execute the variable as sql.

Execute it like a function, not the exec syntax oracle or MS would like. To delete ID row 8 I can now use

select deleteme(8)

Extra points for apple spell check changing postgres to post grease

I should flag that my knowledge is for 8.4 not 9.1