diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/create_type.out | 20 | ||||
| -rw-r--r-- | src/test/regress/sql/create_type.sql | 6 |
2 files changed, 26 insertions, 0 deletions
diff --git a/src/test/regress/expected/create_type.out b/src/test/regress/expected/create_type.out index 0ab85a883c0..2f7d5f94d7b 100644 --- a/src/test/regress/expected/create_type.out +++ b/src/test/regress/expected/create_type.out @@ -191,3 +191,23 @@ TABLE mytab; (-44,5.5,12) (2 rows) +-- and test format_type() a bit more, too +select format_type('varchar'::regtype, 42); + format_type +----------------------- + character varying(38) +(1 row) + +select format_type('bpchar'::regtype, null); + format_type +------------- + character +(1 row) + +-- this behavior difference is intentional +select format_type('bpchar'::regtype, -1); + format_type +------------- + bpchar +(1 row) + diff --git a/src/test/regress/sql/create_type.sql b/src/test/regress/sql/create_type.sql index 07061bc02a6..3d1deba97cf 100644 --- a/src/test/regress/sql/create_type.sql +++ b/src/test/regress/sql/create_type.sql @@ -148,3 +148,9 @@ WHERE attrelid = 'mytab'::regclass AND attnum > 0; -- might as well exercise the widget type while we're here INSERT INTO mytab VALUES ('(1,2,3)'), ('(-44,5.5,12)'); TABLE mytab; + +-- and test format_type() a bit more, too +select format_type('varchar'::regtype, 42); +select format_type('bpchar'::regtype, null); +-- this behavior difference is intentional +select format_type('bpchar'::regtype, -1); |