Insert into array column

I have a column with type integer array (postgresql). But I don't know how to insert data with bindValue. I tried QVariantList, but failed.

Code:

---

QVariantList nomor;
nomor << 1 << 2 << 3 << 4;
 
sql.bindValue(":intarraycolumn", nomor);

---

Need your help

You need to construct a string that will look like this one:
{ youInt1, yourInt2, ..., your intN } and bound it.

you can try something like:

Code:

---

QString nomor;
nomor.append("(");
for (int i=0; i < n;  i++)
    {
     nomor.append(QString::number(i));
     if (i != n-1)
        {
         nomor.append(", ");
        }
    }
nomor.append(")");
 
sql.bindValue(":intarraycolumn", nomor);

---

PostgreSQL's doc says it should be "{...}", not "(...)".