> Regexes are optimized the same way as equivalent LIKE expressions. In
> particular, the pattern has to be left-anchored to consider using it
> with an index. In LIKE that means no wildcard at the start of the
> pattern, in regex it means there has to be a ^.
What about "^.*oobar" in a regex ? I mean, it seems impossible
to use an index on that, right ?
Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
