/[sql]/pgsql2interbase
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /pgsql2interbase

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by dpavlin, Mon Jul 31 06:19:20 2000 UTC revision 1.2 by dpavlin, Mon Jul 31 08:55:32 2000 UTC
# Line 9  Line 9 
9    
10  # 2000-08-30 DbP -- Dobrica Pavlinusic <dpavlin@rot13.org>  # 2000-08-30 DbP -- Dobrica Pavlinusic <dpavlin@rot13.org>
11  #       based on mysql2pgsql  #       based on mysql2pgsql
12    #
13    # Warning: bool datatype is converted to char(1) which will break
14    # your application if you tend to check true values with
15    #       if ($foo)
16    # and not with
17    #       if ($foo = 't')
18    # In data from InterBase it will always return true which is wrong!
19    #
20    
21  $create=0;      # inside create table?  $create=0;      # inside create table?
22  $table="";  $table="";
# Line 41  set term ; !! Line 49  set term ; !!
49                  s/\w*int\d+/ int/gi;                  s/\w*int\d+/ int/gi;
50    
51                  # bool -> char(1)                  # bool -> char(1)
52                  s/\w*bool/ char(1)/gi;                  if (/bool/i) {
53                            s/\w*bool/ char(1)/gi;
54                            print STDERR "Warning: bool emulated by char(1)\n\n";
55                    }
56    
57                  # datetime -> timestamp                  # datetime -> timestamp
58                  s/datetime/timestamp/gi;                  s/datetime/timestamp/gi;

Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2

  ViewVC Help
Powered by ViewVC 1.1.26