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 peter_e@gmx.net