> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
