BUG #4908: escaping and dollar quotes: "ERROR: unterminated string"
| От | Jack Douglas |
|---|---|
| Тема | BUG #4908: escaping and dollar quotes: "ERROR: unterminated string" |
| Дата | |
| Msg-id | 200907082053.n68Kr3Xm090266@wwwmaster.postgresql.org обсуждение |
| Ответы |
Re: BUG #4908: escaping and dollar quotes: "ERROR: unterminated string"
|
| Список | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4908
Logged by: Jack Douglas
Email address: jackpdouglas@gmail.com
PostgreSQL version: 8.3.7
Operating system: Debian Lenny
Description: escaping and dollar quotes: "ERROR: unterminated
string"
Details:
Am I missing something obvious here - I understand from the documentation no
escapes are counted in dollar quoted strings?
postgres=> create or replace function temp() returns text language plpgsql
AS $$
postgres$> begin
postgres$> return '\';
postgres$> end; $$;
ERROR: unterminated string
CONTEXT: compile of PL/pgSQL function "temp" near line 2
I use the following as a workaround:
postgres=> create or replace function temp() returns text language plpgsql
AS $$
postgres$> begin
postgres$> return rtrim('\ ');
postgres$> end; $$;
CREATE FUNCTION
obviously this is a contrived test case to demonstrate the problem, not my
real function :-)
В списке pgsql-bugs по дате отправления: