Re: [PERFORM] Optimizer differences between 7.2 and 7.3

A bit OT: do regex ops (~, ~*) use index scan in non-C locales? Is it worth to convert LIKE to regex? G. --- cut here --- - Original Message - From: Richard Huxton [EMAIL PROTECTED] Sent: Monday, July 07, 2003 4:40 PM Check the

Re: [PERFORM] Optimizer differences between 7.2 and 7.3

=?ISO-8859-1?Q?SZUCS_G=E1bor?= [EMAIL PROTECTED] writes: do regex ops (~, ~*) use index scan in non-C locales? Is it worth to convert LIKE to regex? The locale issues are the same either way. regards, tom lane ---(end of