diff options
Diffstat (limited to 'src/test/regress/sql/strings.sql')
-rw-r--r-- | src/test/regress/sql/strings.sql | 23 |
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; + |