You can create indexes on expressions, like mycustomfunction(a), in Postgres at least.