[GENERAL] PL/pgSQL: how to round a number up?

In PL/pgSQL the round() function seem to round a number down all the time. Is there something like ceil() that would round it up? ScriptHead

[GENERAL] Strugging with NEW and OLD records.

    RETURN NEW;     END; ' LANGUAGE 'plpgsql'; > CREATE TRIGGER update_name_extra BEFORE INSERT ON name EXECUTE PROCEDURE update_name(); > INSERT INTO name(first,last) VALUES('script','head'); ERROR:  record "new" is not assigned yet DETAIL:  The