A bit OT:

do regex ops (~, ~*) use index scan in non-"C" locales? Is it worth to
convert LIKE to regex?

------------------------------- cut here -------------------------------
----- Original Message ----- 
From: "Richard Huxton" <[EMAIL PROTECTED]>
Sent: Monday, July 07, 2003 4:40 PM

Check the locale the database was initdb'd to. You'll probably find 7.2.4 is
in the "C" locale whereas 7.3.3 isn't. The "like" comparison can only use
indexes in the "C" locale. I believe you might need to initdb again to fix

  Richard Huxton

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to