--
-- party__email/1
--
create or replace function party__email(
  integer
) returns varchar as $$

declare
  email__party_id		alias for $1;
begin

  return email from parties where party_id = email__party_id;

end;$$ language plpgsql;