summaryrefslogtreecommitdiffstats
path: root/src/test/modules/test_ddl_deparse/sql/create_domain.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/modules/test_ddl_deparse/sql/create_domain.sql')
-rw-r--r--src/test/modules/test_ddl_deparse/sql/create_domain.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/src/test/modules/test_ddl_deparse/sql/create_domain.sql b/src/test/modules/test_ddl_deparse/sql/create_domain.sql
new file mode 100644
index 0000000..6ab5525
--- /dev/null
+++ b/src/test/modules/test_ddl_deparse/sql/create_domain.sql
@@ -0,0 +1,10 @@
+---
+--- CREATE_DOMAIN
+---
+CREATE DOMAIN domainvarchar VARCHAR(5);
+
+CREATE DOMAIN japanese_postal_code AS TEXT
+CHECK(
+ VALUE ~ '^\d{3}$'
+OR VALUE ~ '^\d{3}-\d{4}$'
+);