Re: Using regular expressions in LIKE

> 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