diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 12:15:05 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 12:15:05 +0000 |
commit | 46651ce6fe013220ed397add242004d764fc0153 (patch) | |
tree | 6e5299f990f88e60174a1d3ae6e48eedd2688b2b /src/test/regress/expected/char_1.out | |
parent | Initial commit. (diff) | |
download | postgresql-14-upstream.tar.xz postgresql-14-upstream.zip |
Adding upstream version 14.5.upstream/14.5upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'src/test/regress/expected/char_1.out')
-rw-r--r-- | src/test/regress/expected/char_1.out | 122 |
1 files changed, 122 insertions, 0 deletions
diff --git a/src/test/regress/expected/char_1.out b/src/test/regress/expected/char_1.out new file mode 100644 index 0000000..6c917c0 --- /dev/null +++ b/src/test/regress/expected/char_1.out @@ -0,0 +1,122 @@ +-- +-- CHAR +-- +-- fixed-length by value +-- internally passed by value if <= 4 bytes in storage +SELECT char 'c' = char 'c' AS true; + true +------ + t +(1 row) + +-- +-- Build a table for testing +-- +CREATE TABLE CHAR_TBL(f1 char); +INSERT INTO CHAR_TBL (f1) VALUES ('a'); +INSERT INTO CHAR_TBL (f1) VALUES ('A'); +-- any of the following three input formats are acceptable +INSERT INTO CHAR_TBL (f1) VALUES ('1'); +INSERT INTO CHAR_TBL (f1) VALUES (2); +INSERT INTO CHAR_TBL (f1) VALUES ('3'); +-- zero-length char +INSERT INTO CHAR_TBL (f1) VALUES (''); +-- try char's of greater than 1 length +INSERT INTO CHAR_TBL (f1) VALUES ('cd'); +ERROR: value too long for type character(1) +INSERT INTO CHAR_TBL (f1) VALUES ('c '); +SELECT * FROM CHAR_TBL; + f1 +---- + a + A + 1 + 2 + 3 + + c +(7 rows) + +SELECT c.* + FROM CHAR_TBL c + WHERE c.f1 <> 'a'; + f1 +---- + A + 1 + 2 + 3 + + c +(6 rows) + +SELECT c.* + FROM CHAR_TBL c + WHERE c.f1 = 'a'; + f1 +---- + a +(1 row) + +SELECT c.* + FROM CHAR_TBL c + WHERE c.f1 < 'a'; + f1 +---- + 1 + 2 + 3 + +(4 rows) + +SELECT c.* + FROM CHAR_TBL c + WHERE c.f1 <= 'a'; + f1 +---- + a + 1 + 2 + 3 + +(5 rows) + +SELECT c.* + FROM CHAR_TBL c + WHERE c.f1 > 'a'; + f1 +---- + A + c +(2 rows) + +SELECT c.* + FROM CHAR_TBL c + WHERE c.f1 >= 'a'; + f1 +---- + a + A + c +(3 rows) + +DROP TABLE CHAR_TBL; +-- +-- Now test longer arrays of char +-- +CREATE TABLE CHAR_TBL(f1 char(4)); +INSERT INTO CHAR_TBL (f1) VALUES ('a'); +INSERT INTO CHAR_TBL (f1) VALUES ('ab'); +INSERT INTO CHAR_TBL (f1) VALUES ('abcd'); +INSERT INTO CHAR_TBL (f1) VALUES ('abcde'); +ERROR: value too long for type character(4) +INSERT INTO CHAR_TBL (f1) VALUES ('abcd '); +SELECT * FROM CHAR_TBL; + f1 +------ + a + ab + abcd + abcd +(4 rows) + |