how to write functions in postgresql

CREATE OR REPLACE FUNCTION getfoo(integer)
  RETURNS SETOF foo AS
$BODY$
    SELECT * FROM foo WHERE fooid = $1;
$BODY$
  LANGUAGE sql VOLATILE;