| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SIMILAR TO |
| Date: | 2002-09-09 18:41:19 |
| Message-ID: | Pine.LNX.4.44.0209091945010.18819-100000@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-09-09 18:41:41 | Re: Proposal: Solving the "Return proper effected tuple |
| Previous Message | Peter Eisentraut | 2002-09-09 18:41:01 | Re: Importing data from 7.2.2 into 7.3b1 !? |