Tom Lane wrote: > AFAICS, getting SIMILAR TO to operate per spec would require adding some > sort of translation function that converts the spec-style pattern into > a Posix pattern that our regex match engine would handle. This would at > least require adding ^ and $ around the pattern, converting the escape > character if any, and translating % and _ into .* and . respectively. > There are probably some differences of detail that we'd need to fix > later, but that would get it to a state where we need not be ashamed > to release it. > > We already have a similar mechanism for handling LIKE ... ESCAPE > clauses, so it doesn't seem too difficult to do. But I haven't got > time for it...
It seems like a merge of regex and LIKE patterns. ANSI doesn't have regex so maybe SIMILAR TO is their solution to that. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
