I'm retrieving a resultset from a Postgres database. One of the fields is of type Array. I cannot seem to retrieve the array value(s) from the result set.
Trying the following:
var tumorTypes = new Array();
var rs = dbConn.executeCachedQuery(sql);
tumorTypes = rs.getArray("tumor_type");
I then try to loop thru the "tumorTypes" array, but no luck. When I do a toString I see that it is being returned as a javax.sql.rowset.serial.SerialArray. Am I missing something?
using v3.1.1
Trying the following:
var tumorTypes = new Array();
var rs = dbConn.executeCachedQuery(sql);
tumorTypes = rs.getArray("tumor_type");
I then try to loop thru the "tumorTypes" array, but no luck. When I do a toString I see that it is being returned as a javax.sql.rowset.serial.SerialArray. Am I missing something?
using v3.1.1
Postgres array datatype
0 commentaires:
Enregistrer un commentaire