Simple change to make Postgres simple array types produce correctly
[dbsrgits/SQL-Translator.git] / t / 47postgres-producer.t
index 547ddf2..10b2bc5 100644 (file)
@@ -14,7 +14,7 @@ use FindBin qw/$Bin/;
 #=============================================================================
 
 BEGIN {
-    maybe_plan(38,
+    maybe_plan(39,
         'SQL::Translator::Producer::PostgreSQL',
         'Test::Differences',
     )
@@ -40,6 +40,20 @@ my $field1_sql = SQL::Translator::Producer::PostgreSQL::create_field($field1);
 
 is($field1_sql, 'myfield character varying(10)', 'Create field works');
 
+my $field_array = SQL::Translator::Schema::Field->new( name => 'myfield',
+                                                  table => $table,
+                                                  data_type => 'character varying[]',
+                                                  size => 10,
+                                                  default_value => undef,
+                                                  is_auto_increment => 0,
+                                                  is_nullable => 1,
+                                                  is_foreign_key => 0,
+                                                  is_unique => 0 );
+
+my $field_array_sql = SQL::Translator::Producer::PostgreSQL::create_field($field_array);
+
+is($field_array_sql, 'myfield character varying(10)[]', 'Create field works');
+
 my $field2 = SQL::Translator::Schema::Field->new( name      => 'myfield',
                                                   table => $table,
                                                   data_type => 'VARCHAR',