"Clint Stotesbery" <cstotes@hotmail.com> writes:
> I know I have to relpace the word PROCEDURE with FUNCTION but then it wants
> me to put RETURNS <datatype> but I don't want to return anything.
You can say RETURNS VOID in recent releases. This is a bit of a hack
but it expresses your intent ... you still have to use SELECT to invoke
the function though.
regression=# create or replace function fooey () returns void as '
regression'# begin
regression'# raise notice ''fooey'';
regression'# return;
regression'# end' language plpgsql;
CREATE FUNCTION
regression=# select fooey();
NOTICE: fooeyfooey
-------
(1 row)
regression=#
regards, tom lane