diff options
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/regress/expected/strings.out | 18 | ||||
-rw-r--r-- | src/test/regress/sql/strings.sql | 4 |
2 files changed, 22 insertions, 0 deletions
diff --git a/src/test/regress/expected/strings.out b/src/test/regress/expected/strings.out index f8cba9f5b24..fbe7d7be71f 100644 --- a/src/test/regress/expected/strings.out +++ b/src/test/regress/expected/strings.out @@ -236,6 +236,24 @@ SELECT E'De\\678dBeEf'::bytea; ERROR: invalid input syntax for type bytea LINE 1: SELECT E'De\\678dBeEf'::bytea; ^ +SELECT reverse(''::bytea); + reverse +--------- + \x +(1 row) + +SELECT reverse('\xaa'::bytea); + reverse +--------- + \xaa +(1 row) + +SELECT reverse('\xabcd'::bytea); + reverse +--------- + \xcdab +(1 row) + SET bytea_output TO escape; SELECT E'\\xDeAdBeEf'::bytea; bytea diff --git a/src/test/regress/sql/strings.sql b/src/test/regress/sql/strings.sql index 4deb0683d57..ed054e6e99c 100644 --- a/src/test/regress/sql/strings.sql +++ b/src/test/regress/sql/strings.sql @@ -77,6 +77,10 @@ SELECT E'De\123dBeEf'::bytea; SELECT E'De\\123dBeEf'::bytea; SELECT E'De\\678dBeEf'::bytea; +SELECT reverse(''::bytea); +SELECT reverse('\xaa'::bytea); +SELECT reverse('\xabcd'::bytea); + SET bytea_output TO escape; SELECT E'\\xDeAdBeEf'::bytea; SELECT E'\\x De Ad Be Ef '::bytea; |