It seems that PQescapeStringConn is insufficient to avoid the warning
"WARNING: nonstandard use of escape in a string literal". I'm
running the regression tests.
a-file-with-a-slash\-in-itlocalhost-dir
becomes
a-file-with-a-slash\\-in-itlocalhost-dir
regress=# SELECT FilenameId FROM Filename WHERE Name='a-file-with-a-
slash\\-in-itlocalhost-dir';
WARNING: nonstandard use of \\ in a string literal
LINE 1: SELECT FilenameId FROM Filename WHERE Name='a-file-with-a-
sl...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
filenameid
------------
(0 rows)
regress=#
Any ideas how to use the E'\\' syntax?
FYI, this works:
regress=# SELECT FilenameId FROM Filename WHERE Name='a-file-with-a-
slash' || E'\\' || '-in-itlocalhost-dir';
filenameid
------------
(0 rows)
regress=#
I'd rather use PostgreSQL functions instead of rolling my own.
Suggestions? Ideas?
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
