aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/domain.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/domain.sql')
-rw-r--r--src/test/regress/sql/domain.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/src/test/regress/sql/domain.sql b/src/test/regress/sql/domain.sql
index 68da27de22b..1291d550d68 100644
--- a/src/test/regress/sql/domain.sql
+++ b/src/test/regress/sql/domain.sql
@@ -680,6 +680,26 @@ create domain di as int;
create function dom_check(int) returns di as $$
declare d di;
begin
+ d := $1::di;
+ return d;
+end
+$$ language plpgsql immutable;
+
+select dom_check(0);
+
+alter domain di add constraint pos check (value > 0);
+
+select dom_check(0); -- fail
+
+alter domain di drop constraint pos;
+
+select dom_check(0);
+
+-- implicit cast during assignment is a separate code path, test that too
+
+create or replace function dom_check(int) returns di as $$
+declare d di;
+begin
d := $1;
return d;
end