Hello
2009/11/16 Konstantin Izmailov <pgfizm@gmail.com>:
> I'm planning to use multiple statements via libpq. Before starting coding
> I'm trying to understand are there any limitations on passing parameters.
> E.g. would the following work:
> PQexecParams(conn, "BEGIN;INSERT INTO tbl VALUES($1,$2);SELECT
> lastval();SELECT * INTO AUDIT FROM (SELECT $3, 'tbl action',
> lastval());COMMIT;", 3, ...);
>
sorry, it is not direct reply on your question, but why don't you use
simply stored procedure?
btw. It looks like case for trigger
did you know RETURNING clause?
your code is very cumbrous
Regards
Pavel Stehule
> Thank you!
