From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: array_agg and libpq(xx) |
Date: | 2009-03-20 00:49:09 |
Message-ID: | b42b73150903191749v5971c9c1qd25f292756ebc323@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2009/3/19 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:
> 2009/3/19 Merlin Moncure <mmoncure(at)gmail(dot)com>:
>
>> if you are moving arrays (and/or composites) into out of database
>> through libpq, check out libpqtypes:
>>
>> http://libpqtypes.esilo.com/
>
> Thanks, I will have to do it via libpqxx unfortunately. Which
> complicates matter a bit, since they don't expose libpq. (which for
> instance sux, because there's no equivalent of execParam() in pqxx,
> and prepared statements aren't always what I am aiming for..).
I see. well, libpqxx is just a wrapper to libpq, same as libpqtypes.
Barring that, your best bet is to parse the string or unnest the array
in the query.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Williamson | 2009-03-20 01:15:37 | Re: Is there a meaningful benchmark? |
Previous Message | jc_mich | 2009-03-20 00:25:03 | Initializing variables from SQL query |