Re: SIMILAR TO - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: SIMILAR TO
Date
Msg-id 200209110424.g8B4OH914121@candle.pha.pa.us
Whole thread Raw
In response to Re: SIMILAR TO  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: SIMILAR TO  (Peter Eisentraut <peter_e@gmx.net>)
List 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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re:
Next
From: Alvaro Herrera
Date:
Subject: TOAST docs