Thank you! Robert,
>
> select * from tt1 where c1=(select f1('x'));
> update tt1 set c2='ABC' WHERE c1=(select f1('x'));
>
> I think there might be other benefits to this in regards to index usage
> as well.
>
Indeed this fix the problem.
However, when this is in rule, function f1 is called repeatedly again. Any idea?
Regards,
CN
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze