Re: SIMILAR TO

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