Fix Pg date/time types with zero fractional second digits

[dbsrgits/DBIx-Class-Schema-Loader.git] / t / 10_03pg_common.t

diff --git a/t/10_03pg_common.t b/t/10_03pg_common.t
index 1033264..1d392dd 100644 (file)
--- a/t/10_03pg_common.t
+++ b/t/10_03pg_common.t
@@ -121,22 +121,28 @@ dbixcsl_common_tests->new(
         # Datetime Types
         date                             => { data_type => 'date' },
         interval                         => { data_type => 'interval' },
+        'interval(0)'                    => { data_type => 'interval', size => 0 },
         'interval(2)'                    => { data_type => 'interval', size => 2 },
         time                             => { data_type => 'time' },
+        'time(0)'                        => { data_type => 'time', size => 0 },
         'time(2)'                        => { data_type => 'time', size => 2 },
         'time without time zone'         => { data_type => 'time' },
-        'time(2) without time zone'      => { data_type => 'time', size => 2 },
+        'time(0) without time zone'      => { data_type => 'time', size => 0 },
         'time with time zone'            => { data_type => 'time with time zone' },
+        'time(0) with time zone'         => { data_type => 'time with time zone', size => 0 },
         'time(2) with time zone'         => { data_type => 'time with time zone', size => 2 },
         timestamp                        => { data_type => 'timestamp' },
         'timestamp default now()'        => { data_type => 'timestamp',
                                               default_value => \'current_timestamp',
                                               original => { default_value => \'now()' } },
+        'timestamp(0)'                   => { data_type => 'timestamp', size => 0 },
         'timestamp(2)'                   => { data_type => 'timestamp', size => 2 },
         'timestamp without time zone'    => { data_type => 'timestamp' },
+        'timestamp(0) without time zone' => { data_type => 'timestamp', size => 0 },
         'timestamp(2) without time zone' => { data_type => 'timestamp', size => 2 },
 
         'timestamp with time zone'       => { data_type => 'timestamp with time zone' },
+        'timestamp(0) with time zone'    => { data_type => 'timestamp with time zone', size => 0 },
         'timestamp(2) with time zone'    => { data_type => 'timestamp with time zone', size => 2 },
 
         # Blob Types