Re: [SQL] regex engine

2004-07-25 Thread Markus Bertheau
Ð ÐÑÐ, 25.07.2004, Ð 21:41, Tom Lane ÐÐÑÐÑ: > Markus Bertheau <[EMAIL PROTECTED]> writes: > > pg's regex engine does have one > > shortcoming though: it doesn't know UTF-8. > > Sure it does. We borrowed it from Tcl, remember? > > The "character class" stuff is not locale-aware at the moment, > w

Re: [SQL] regex engine

2004-07-25 Thread Tom Lane
Markus Bertheau <[EMAIL PROTECTED]> writes: > pg's regex engine does have one > shortcoming though: it doesn't know UTF-8. Sure it does. We borrowed it from Tcl, remember? The "character class" stuff is not locale-aware at the moment, which is something that ought to get fixed eventually, but cl

Re: [SQL] regex engine

2004-07-25 Thread Markus Bertheau
Ð ÐÑÐ, 25.07.2004, Ð 19:34, Tom Lane ÐÐÑÐÑ: > Markus Bertheau <[EMAIL PROTECTED]> writes: > > Ð ÐÑÐ, 25.07.2004, Ð 16:40, Jean-Luc Lachance ÐÐÑÐÑ: > >> Better yet: > >> > >> SELECT * FROM table WHERE phrase ~ '^[0-9]'; > > > Not so sure if that's better - the regex engines aren't the fastest. >