Thomas Lockhart writes: > > SIMILAR TO doesn't implement the SQL standard, it's only a wrapper around > > the POSIX regexp matching, which is wrong. I thought someone wanted to > > fix that, but if it's not happening it should be removed. > > Please be specific on what you would consider correct. I'm not recalling > any details of past discussions so need some background.
The pattern that should be accepted by SIMILAR TO (as defined in SQL99 part 2 clause 8.6) and the POSIX regular expressions that it accepts now are not the same. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]