summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/sql/dynalloc.pgc
diff options
context:
space:
mode:
Diffstat (limited to 'src/interfaces/ecpg/test/sql/dynalloc.pgc')
-rw-r--r--src/interfaces/ecpg/test/sql/dynalloc.pgc2
1 files changed, 2 insertions, 0 deletions
diff --git a/src/interfaces/ecpg/test/sql/dynalloc.pgc b/src/interfaces/ecpg/test/sql/dynalloc.pgc
index 766d2365914..797dd18e205 100644
--- a/src/interfaces/ecpg/test/sql/dynalloc.pgc
+++ b/src/interfaces/ecpg/test/sql/dynalloc.pgc
@@ -32,6 +32,8 @@ int main(void)
exec sql whenever sqlerror do sqlprint();
exec sql connect to REGRESSDB1;
+ exec sql set datestyle to mdy;
+
exec sql create table test (a serial, b numeric(12,3), c varchar, d varchar(3), e char(4), f timestamptz, g boolean, h box, i inet);
exec sql insert into test (b, c, d, e, f, g, h, i) values (23.456, 'varchar', 'v', 'c', '2003-03-03 12:33:07 PDT', true, '(1,2,3,4)', '2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128');
exec sql insert into test (b, c, d, e, f, g, h, i) values (2.446456, NULL, 'v', 'c', '2003-03-03 12:33:07 PDT', false, NULL, NULL);