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 universally
> unreasonable?
Regex patterns don't have the notion of a quoted substring at all, so
it seems moderately unreasonable to me to expect dollar quoting to mean
something to regex (even discounting the fact that it couldn't work
lexically because $ has different lexical properties in a regex
pattern).
The dollar quote stuff is documented as a SQL string constant
representation. It doesn't seem to me that you'd expect it to work
anywhere except in SQL statements.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
