Re: arrays returned in text format - Mailing list pgsql-general

Konstantin Izmailov <pgfizm@gmail.com> writes:
> I'm using libpq to read array values, and I noticed that sometimes the
> values are returned in Binary and sometimes - in Text format.

> 1. Returned in Binary format:
>    int formats[1] = { 1 }; // request binary format
>    res = PQexec(conn, "SELECT rgField FROM aTable", 1, formats);
>    assert(PQfformat(res, 0) == 1);  // this is OK

> 2. Returned in Text format:
>    res = PQexec(conn, "SELECT ARRAY[1,2,3]", 1, formats);
>    assert(PQfformat(res, 0) == 1);  // this fails???

Um, that is not the call signature of PQexec(), nor of any of its
variants.

            regards, tom lane