Peter, > > 4) It's just as indexible (or not indexable) as regexp comparisons, and > > easier to understand for users from the Microsoft world than regexp. > > ILIKE is not indexible at all. Other forms of pattern comparisons are at > least indexible sometimes.
And how is ~* indexable? -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
