Title: Re: [GENERAL] back slash separated values
SHOW
server_version; server_version 8.0.6(1
row)
the stored procedure is
:
CREATE OR REPLACE FUNCTION update_exam_modality(bigint,
varchar(16)) RETURNS text AS'DECLARE mod_of_study
varchar(16); mod_pa
"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 a
What's the version of pgsql?
postgres=# show server_version;
server_version
8.1.0
(1 row)
postgres=# CREATE OR REPLACE FUNCTION foo (v_s1 varchar, v_s2 varchar)
postgres-# RETURNS varchar AS $$
postgres$# BEGIN
postgres$# RETURN v_s1 || '\\' || v_s2;
postgres$# END;
postgre
mod_pattern := mod_of_study
|| ''\\'' || $2;
is giving me syntax error, please tell how
i can concat a backslah cgaracter.
Thanks,
regards
Surabhi
