CREATE FUNCTION trigger_pepl_before ()
RETURNS trigger AS $$
BEGIN
NEW.pepl_login=COALESCE(NEW.pepl_login,'User'||NEW.pepl_id);
return NEW;
END;
$$ LANGUAGE  plpgsql;

CREATE TRIGGER people_trigger
BEFORE INSERT ON people FOR EACH ROW
EXECUTE PROCEDURE trigger_pepl_before ();