Re: array_agg and libpq(xx)

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

In response to

Browse pgsql-general by date

  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