"surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx> 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
