aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2000-01-17 00:16:41 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2000-01-17 00:16:41 +0000
commit2d4a05d7dfc475c65b838642e26da407561267bc (patch)
tree66192635346c6c124de236d7ee1abab357e20004 /src
parent49528361f521b432da2cfafcb81cade17eb324d1 (diff)
downloadpostgresql-2d4a05d7dfc475c65b838642e26da407561267bc.tar.gz
postgresql-2d4a05d7dfc475c65b838642e26da407561267bc.zip
Update strings test to reflect the fact that casting to char() will
now truncate or pad to the specified length.
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/strings.out28
-rw-r--r--src/test/regress/sql/strings.sql8
2 files changed, 18 insertions, 18 deletions
diff --git a/src/test/regress/expected/strings.out b/src/test/regress/expected/strings.out
index 36a0f12e957..c2687844c00 100644
--- a/src/test/regress/expected/strings.out
+++ b/src/test/regress/expected/strings.out
@@ -45,26 +45,26 @@ SELECT CAST(name 'namefield' AS text) AS "text(name)";
namefield
(1 row)
-SELECT CAST(f1 AS char) AS "char(text)" FROM TEXT_TBL;
- char(text)
--------------------
- doh!
- hi de ho neighbor
+SELECT CAST(f1 AS char(10)) AS "char(text)" FROM TEXT_TBL;
+ char(text)
+------------
+ doh!
+ hi de ho n
(2 rows)
-SELECT CAST(f1 AS char) AS "char(varchar)" FROM VARCHAR_TBL;
+SELECT CAST(f1 AS char(10)) AS "char(varchar)" FROM VARCHAR_TBL;
char(varchar)
---------------
- a
- ab
- abcd
- abcd
+ a
+ ab
+ abcd
+ abcd
(4 rows)
-SELECT CAST(name 'namefield' AS char) AS "char(name)";
+SELECT CAST(name 'namefield' AS char(10)) AS "char(name)";
char(name)
------------
- namefield
+ namefield
(1 row)
SELECT CAST(f1 AS varchar) AS "varchar(text)" FROM TEXT_TBL;
@@ -155,10 +155,10 @@ SELECT text 'text' || ' and unknown' AS "Concat text to unknown type";
text and unknown
(1 row)
-SELECT text 'text' || char ' and char' AS "Concat text to char";
+SELECT text 'text' || char(10) ' and characters' AS "Concat text to char";
Concat text to char
---------------------
- text and char
+ text and chara
(1 row)
SELECT text 'text' || varchar ' and varchar' AS "Concat text to varchar";
diff --git a/src/test/regress/sql/strings.sql b/src/test/regress/sql/strings.sql
index 7be0073a6fc..2726744383d 100644
--- a/src/test/regress/sql/strings.sql
+++ b/src/test/regress/sql/strings.sql
@@ -25,11 +25,11 @@ SELECT CAST(f1 AS text) AS "text(varchar)" FROM VARCHAR_TBL;
SELECT CAST(name 'namefield' AS text) AS "text(name)";
-SELECT CAST(f1 AS char) AS "char(text)" FROM TEXT_TBL;
+SELECT CAST(f1 AS char(10)) AS "char(text)" FROM TEXT_TBL;
-SELECT CAST(f1 AS char) AS "char(varchar)" FROM VARCHAR_TBL;
+SELECT CAST(f1 AS char(10)) AS "char(varchar)" FROM VARCHAR_TBL;
-SELECT CAST(name 'namefield' AS char) AS "char(name)";
+SELECT CAST(name 'namefield' AS char(10)) AS "char(name)";
SELECT CAST(f1 AS varchar) AS "varchar(text)" FROM TEXT_TBL;
@@ -65,7 +65,7 @@ SELECT 'unknown' || ' and unknown' AS "Concat unknown types";
SELECT text 'text' || ' and unknown' AS "Concat text to unknown type";
-SELECT text 'text' || char ' and char' AS "Concat text to char";
+SELECT text 'text' || char(10) ' and characters' AS "Concat text to char";
SELECT text 'text' || varchar ' and varchar' AS "Concat text to varchar";