From: "Stephan Szabo" <[EMAIL PROTECTED]> > You need to have made the database in C locale in order to get index scans > from LIKE. I think that's mentioned in the Localization section of the > admin guide, but I could be remembering that wrong.
Thanks very much Stephan. Indeed it's in Admin Guide 5.1.2. I was using en_GB, not C. There is of course no excuse for failing to read every bit of smallprint in the admin guide before installation :-) but for those lazy unfortunates like me that don't think to look there to find out what's wrong when indexes aren't used with LIKE, I've added a DocNote under Pattern Matching. Julian Scarfe ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
