Search Postgresql Archives

arrays returned in text format

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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???

This is not a big issue, I can parse the text representation of the array. But I wanted to understand why Postgres returns data in Text format when Binary was requested. Am I missing something?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux