/*
 * This test is ported from pgloader 2.x where it was defined as:
 *
 * [fixed]
 * table           = fixed
 * format          = fixed
 * filename        = fixed/fixed.data
 * columns         = *
 * fixed_specs     = a:0:10, b:10:8, c:18:8, d:26:17
 * reformat        = c:pgtime:time
 *
 */

LOAD FIXED
     FROM inline
          (
           a from  0 for 10,
           b from 10 for  8,
           c from 18 for  8,
           d from 26 for 17 [null if blanks, trim right whitespace]
          )
     INTO postgresql:///pgloader
   TARGET TABLE fixed
          (
             a, b,
             c time using (time-with-no-separator c),
             d
          )

     WITH truncate, drop indexes

      SET client_encoding to 'latin1',
          work_mem to '14MB',
          standard_conforming_strings to 'on'

   BEFORE LOAD DO
     $$ drop table if exists fixed; $$,
     $$ create table fixed (
         a integer primary key,
         b date,
         c time,
         d text
        );
     $$;




01234567892008052011431250firstline        
   01234562008052115182300left blank-padded
12345678902008052208231560another line     
 2345609872014092914371500                 
 2345678902014092914371520