I am trying to search for a matching values in an integer array using a postgres prepared statement, similar to this
//Postgres:
//CREATE TABLE accounts (id INTEGER)
//Xojo:
dim aNumber(3) as Integer
aNumber(0) = 12
aNumber(1) = 17
aNumber(2) = 25
aNumber(3) = 50
dim sql as String
sql = "Select * from accounts WHERE id IN ($1)"
dim ps as PostgresPreparedStatement = db.Prepare(sql)
ps.Bind(0,aNumber()) //<---Not sure how to get this array as a parameter
dim rs as Recordset = ps.SQLSelect
I tried putting the array into a String separated by commas, but Postgres said invalid input for type integer.
Thanks for any help here.