Re: SIMILAR TO - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: SIMILAR TO
Date
Msg-id 3D7A96FD.9D082404@fourpalms.org
Whole thread Raw
In response to SIMILAR TO  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: SIMILAR TO  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> 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.

I see mention in my SQL99 docs of escape characters for "similar
pattern" which would suggest that it resembles Posix regexp matching. I
don't have the code in front of me to check on the details of the
current implementation, but I'd hope that you have something helpful to
say on what a better implementation would be.

Regards.
                - Tom


pgsql-hackers by date:

Previous
From: Ajay Ayyagari
Date:
Subject: Mac OS X 10.2/Darwin 6.0
Next
From: Bruno Wolff III
Date:
Subject: Re: [GENERAL] Making small bits of code available