summaryrefslogtreecommitdiff
path: root/contrib/pgcrypto/sql
diff options
context:
space:
mode:
authorBruce Momjian2006-03-08 03:51:52 +0000
committerBruce Momjian2006-03-08 03:51:52 +0000
commitdaab4a101fc1198c20992c036157dd2a4b588a68 (patch)
tree9ce111c82c2ce696dae473e92cc58b5c201157e4 /contrib/pgcrypto/sql
parent43ceb3d4493dc7bcd9a32302b04bd31f1f0edffc (diff)
Update /contrib regression tests for escape_string_warning.
Diffstat (limited to 'contrib/pgcrypto/sql')
-rw-r--r--contrib/pgcrypto/sql/pgp-encrypt.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/contrib/pgcrypto/sql/pgp-encrypt.sql b/contrib/pgcrypto/sql/pgp-encrypt.sql
index b663e051aec..03b34c8ad25 100644
--- a/contrib/pgcrypto/sql/pgp-encrypt.sql
+++ b/contrib/pgcrypto/sql/pgp-encrypt.sql
@@ -85,12 +85,12 @@ select pgp_sym_decrypt(
-- crlf
select encode(pgp_sym_decrypt_bytea(
- pgp_sym_encrypt('1\n2\n3\r\n', 'key', 'convert-crlf=1'),
+ pgp_sym_encrypt(E'1\n2\n3\r\n', 'key', 'convert-crlf=1'),
'key'), 'hex');
-- conversion should be lossless
select encode(digest(pgp_sym_decrypt(
- pgp_sym_encrypt('\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'),
+ pgp_sym_encrypt(E'\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'),
'key', 'convert-crlf=1'), 'sha1'), 'hex') as result,
- encode(digest('\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect;
+ encode(digest(E'\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect;