Hello all,
I've a problem with escaping a \ in a string.
When I enter the query:
SELECT '''\\\''; I get the right result: '\'
But when I try this in a Function:
CREATE FUNCTION sp_tmp() RETURNS varchar(10)
AS ' SELECT ''\\\' AS RESULT'
LANGUAGE 'sql';
I get the following Parse-erros:
psql:tmp1:4: ERROR: Unterminated quoted string. I don't understand why,
when you leave the SELECT-statement out you get '''\\\'' and that is not
unterminated.
Please help
Greetings
Martijn van Dijk