"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> mod_pattern := mod_of_study || ''\\'' || $2;
If this is in a function body, you need four backslashes not two, for
the same reason that you need to double the quote marks: one level of
quotes and backslashes is eaten when the function body is parsed as a
string literal.
If you are on a recent PG version, you should consider switching to
dollar-quotes for the function body. Then you don't need to double
anything, and the constant looks the same as it would look in plain
SQL: mod_of_study || '\\' || $2;
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
