Re: [BUGS] Dollar quoting inside a regex bracket expression

2004-09-27 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > Mis-expectations. I expected--unreasonably, I see--every part of > 8.0beta to do dollar quoting and didn't see how the cases of, say, > pl/python and the regex engine were similar. Is this worth a mention > as part of the regex docs, or is my expectation

Re: [BUGS] Dollar quoting inside a regex bracket expression

2004-09-27 Thread David Fetter
On Sun, Sep 26, 2004 at 11:45:42PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > CREATE OR REPLACE FUNCTION has_bad_chars(text) RETURNS BOOLEAN > > AS $function$ > > SELECT $1 ~ $q$[\t\r\n\v|$qq$\$qq$]$q$; > > $function$ LANGUAGE SQL; > > Why would you expect that to w