Return from stored procedures

Probably a very simple question, but how do you define a function that
returns the sucess of an insert or update in a function i.e.

CREATE FUNCTION foo ( varchar, int8 ) RETURNS bool
AS 'UPDATE table WHERE something'
LANGUAGE 'sql';

Cheers

Graham