Hi group,

I have a user defined function MyF which is pretty slow.  In a where 
clause, I would like MyF to be run last.

example

select * from users where age>10 AND weight>100 AND MyF(data)==true

considering MyF is slow, I only want it to run if it first passes the 
initial conditions (which should be fast).  I assume H2 will stop checking 
conditions once there is a single false.  Is there any way to guarantee 
that the user defined function is called last?

-Adam

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to