> > 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