On 18/08/07, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
