| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SIMILAR TO |
| Date: | 2002-09-08 00:17:01 |
| Message-ID: | 3D7A96FD.9D082404@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2002-09-08 04:14:20 | Re: [GENERAL] Making small bits of code available |
| Previous Message | Ajay Ayyagari | 2002-09-07 22:54:32 | Mac OS X 10.2/Darwin 6.0 |