Re: FInding "corrupt" values in UTF-8 tables (regexp question, I think)

On 18/08/07, Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:
> [Please reply to the list so that others may benefit from and
> participate in the discussion.]
>
> >> If you're including - in a range as a character, doesn't it have to
> >> go first?
> >> Try this:
> >>
> >> WHERE t_code ~ $re$[^-A-Za-z1-9_]$re$
> >>
> >>
> >
> >
> >
> > Thanks, yes, this is sweet!
> >
> > If I include this into a check constraint on the table, would that be
> > very resource intensive for INSERTs and UPDATEs?
> >
>
> Maybe. I don't know. What's very? Measure, change, and measure again.
> Premature optimization and all that. :) First I make it correct.

Yes, I meant to reply all. Thanks much for your help. I'll play around
with the check constraint.