| From: | Konstantin Izmailov <pgfizm(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | arrays returned in text format |
| Date: | 2016-03-05 04:32:55 |
| Message-ID: | CAAw-MsdLP=pDNUdw_czz9Fzqv40jXjmm31KED5XTF5t-qOFdzQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-03-05 05:03:27 | Re: arrays returned in text format |
| Previous Message | David G. Johnston | 2016-03-05 00:03:57 | Re: multiple UNIQUE indices for FK |