Postgres array datatype

lundi 15 décembre 2014

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





Postgres array datatype

0 commentaires:

Enregistrer un commentaire