aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/strings.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/strings.sql')
-rw-r--r--src/test/regress/sql/strings.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/src/test/regress/sql/strings.sql b/src/test/regress/sql/strings.sql
new file mode 100644
index 00000000000..50453043b13
--- /dev/null
+++ b/src/test/regress/sql/strings.sql
@@ -0,0 +1,23 @@
+--
+-- Test various data entry syntaxes.
+--
+
+-- SQL92 string continuation syntax
+SELECT 'first line'
+' - next line'
+ ' - third line'
+ AS "Three lines to one";
+
+-- illegal string continuation syntax
+SELECT 'first line'
+' - next line' /* this comment is not allowed here */
+' - third line';
+
+--
+-- test conversions between various string types
+--
+
+SELECT text(f1) FROM CHAR_TBL;
+
+SELECT text(f1) FROM VARCHAR_TBL;
+