Re: back slash separated values

"surabhi.ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> 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