CREATE OR REPLACE FUNCTION lowercase_usename() RETURNS TRIGGER AS '
    DECLARE
        cant INTEGER:= 0;
    BEGIN
	NEW.username= lower(NEW.username);
        RETURN NEW;
    END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER tr_lowercase_usename BEFORE INSERT OR UPDATE ON TABLE
FOR EACH ROW EXECUTE PROCEDURE lowercase_usename();