[GENERAL] Multiple statements in one prepare / exec

2004-03-28 Thread Robert Turnbull
Can multiple SQL statements be concatenated with separating semicolons, prepared with a single statement, and executed with a single statement? This implies that parameter $1 could be used in statement 2 & 4, ...   My interface is libpq   Thanks Rob

[GENERAL] Prepare a query in linpq?

2004-03-28 Thread Robert Turnbull
How does one use a prepared select statement as outlined in the documents under the prepare statement. I need an example how to convert the plan to cursor so the results can be pulled.   My environment is linpq Version 7.2 Linux X86.   Thanks