Re: [HACKERS] SQL92 - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] SQL92
Date
Msg-id 36145EA4.7192AA36@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] SQL92  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] SQL92  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> > You need The SQL3 SIMILAR
> > in this case pattern can involve additional special characters, not
> > just % and _ as in LIKE,
> TODO item changed to:
>         * add SIMILAR to allow character classes, 'pg_[a-c]%'

The annoying thing is that our regex "~" operators do all of this and
more, but presumably don't have the right behavior for underscore and
for percent. Should we look at the regex code and try to get it to be
compatible (for v6.5...)?

                        - Tom

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: delete from ..;vacuum crashes
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] SQL92