Re: NULLs in ecpg

wespvp(at)syntegra(dot)com wrote:
> What is the scope of a BEGIN or an implicit transaction in ECPG? Is
> it a physical subroutine, or can it span functions containing EXEC
> SQL statements?

It is independent of the control flow of your C program. Only the order
of the actually executed SQL statements matters.

> For example, if I have:
>
>
> void a (xxx)
> {
> EXEC SQL SELECT ... for UPDATE;
> EXEC SQL UPDATE ...
> }
>
> void b (xxx)
> {
> EXEC SQL begin;
>
> a(xxxx);
>
> a(yyyy);
>
> EXEC SQL COMMIT;
> }
>
>
> Do the multiple calls to 'a' remain in the same transaction?

Indeed

--
Peter Eisentraut
http://developer.postgresql.org/~petere/