diff options
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.sql | 10 |
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}$' +); |