At 2008-06-30 13:17:42 +0200, [EMAIL PROTECTED] wrote:
>
> It seems that the most efficient way to communicate with the
> DB would be through PQexecParams(), which avoids the whole
> bytea-encoding issues.
Yes.
> Does it become $10 or ${10} or $(10) or is it simply not possible
> te reference more than nine parameters this way?
$10 etc.
> - Say that the SELECT returns 1000 rows of 100MB each, is there a way
> to avoid PQexecParams() from wanting to allocate 1000*100MB = 100GB
Use a cursor and keep executing FETCH.
-- ams
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
