Re: Dollar quoting inside a regex bracket expression

On Sun, Sep 26, 2004 at 11:45:42PM -0400, Tom Lane wrote:
> David Fetter <david@fetter.org> 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 david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!