Insert into array column

[wirasto]

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.

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

QVariantList nomor;
nomor << 1 << 2 << 3 << 4;

sql.bindValue(":intarraycolumn", nomor);

To copy to clipboard, switch view to plain text mode 

Need your help

[lyuts]

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

[Goldmmbr]

you can try something like:

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);

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);

To copy to clipboard, switch view to plain text mode 

[lyuts]

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