| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: array_agg and libpq(xx) |
| Date: | 2009-03-19 22:28:38 |
| Message-ID: | 2f4958ff0903191528i46ad4bcld6ae422e2a6b2f6d@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/3/19 John R Pierce <pierce(at)hogranch(dot)com>:
> pgResult = PQexec(pgConn, "select array['123','456','abc','def'];");
> pgarray = PQgetvalue(pgResult,0,0);
>
> will return a pointer to the ARRAY in postgres format as defined by the
> typsend/recieve internal functions for the ARRAY type. you would need to
> walk this and copy the strings comprising the array to your own managed
> storage (malloc, or whatever) prior to calling PQclear(pgResult). I'm
> trying to find the docs on what the typsend format for ARRAY looks like and
> failing.
Clearly looking like libpqq(xx) are missing that functionality built
in to protocol/api...
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-03-19 22:28:57 | Re: Is there a meaningful benchmark? |
| Previous Message | Michael Higgins | 2009-03-19 22:28:35 | Re: Special charaters |