Re: [GENERAL] using PREPAREd statements in CURSOR

2007-06-28 Thread Björn Lundin
28 jun 2007 kl. 16.45 skrev Tom Lane: =?ISO-8859-1?Q?Bj=F6rn_Lundin?= <[EMAIL PROTECTED]> writes: I'm connecting via libpq and want to use prepared statements in a cursor. You can't. That explains why I could not find an example... If you're just interested in fetching a large query resu

Re: [GENERAL] using PREPAREd statements in CURSOR

2007-06-28 Thread Tom Lane
=?ISO-8859-1?Q?Bj=F6rn_Lundin?= <[EMAIL PROTECTED]> writes: > I'm connecting via libpq and want to > use prepared statements in a cursor. You can't. If you're just interested in fetching a large query result in sections, there is protocol-level support for doing that without an explicit cursor, b

[GENERAL] using PREPAREd statements in CURSOR

2007-06-28 Thread Björn Lundin
Hello! I'm connecting via libpq and want to use prepared statements in a cursor. Is there a sample somewhere, since I cannot get it to work. sebjlun=# \d ssignal Table "public.ssignal" Column | Type | Modifiers -+---+--- ssignam | character(12) | not