Re: SIMILAR TO
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Thomas Lockhart <lockhart@fourpalms.org>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2002-09-11T04:24:17Z
Lists: pgsql-hackers
Is this a TODO? --------------------------------------------------------------------------- Peter Eisentraut wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073