Index: trunk/archive/psdb/test.c
===================================================================
--- trunk/archive/psdb/test.c	(revision 3166)
+++ trunk/archive/psdb/test.c	(revision 3175)
@@ -48,4 +48,17 @@
 
     psFree(md);
+    
+    // setup horses table for later tests
+    {
+        psMetadata      *md;
+        psMetadataItem  *item;
+
+        md = psMetadataAlloc();
+        item = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "100");
+        psMetadataAddItem(md, item, 3);
+        psFree(item);
+        psDBCreateTable(dbh, "horses", md);
+        psFree(md);
+    }
 
     // psDBSelectColumn()
@@ -103,7 +116,48 @@
     psFree(md);
 
+    //psDBInsertRows();
+
+    {
+        psArray         *rowSet;
+        psMetadata      *row;
+        psMetadataItem  *field;
+
+        rowSet = psArrayAlloc(3);
+        rowSet->n = 0;
+
+        row = psMetadataAlloc();
+        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "brown"); 
+        psMetadataAddItem(row, field, 0);
+        psFree(field);
+        psArrayAdd(rowSet, 0, row);
+        psFree(row);
+
+        row = psMetadataAlloc();
+        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, ""); 
+        psMetadataAddItem(row, field, 0);
+        psFree(field);
+        psArrayAdd(rowSet, 0, row);
+        psFree(row);
+
+        row = psMetadataAlloc();
+        field = psMetadataItemAlloc("color", PS_TYPE_PTR, PS_META_STR, NULL, "pink"); 
+        psMetadataAddItem(row, field, 0);
+        psFree(field);
+        psArrayAdd(rowSet, 0, row);
+        psFree(row);
+
+        if (psDBInsertRows(dbh, "horses", rowSet)) {
+            printf("psDBInsertRows() succeeded\n");
+        }
+
+        psFree(rowSet);
+    }
+
     //psDBDumpRows();
     resultSet = psDBDumpRows(dbh, "horses");
     psFree(resultSet);
+
+    // cleanup other tests
+    psDBDropTable(dbh, "horses");
 
     // close db