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 work?
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 universally unreasonable? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
