Re: [GENERAL] returning value from inside a transaction

2001-09-14 Thread Stephan Szabo
On Wed, 12 Sep 2001, Matt wrote: > create table tez (i int); > insert into tez values(3); > > create function tezt0(int) returns int as ' > begin work; > lock table tez; > select * from tez as r; > commit work; > > select tez.i; > ' language 'sql'; It looks to me from testing r

[GENERAL] returning value from inside a transaction

2001-09-14 Thread Matt
create table tez (i int); insert into tez values(3); create function tezt0(int) returns int as ' begin work; lock table tez; select * from tez as r; commit work; select tez.i; ' language 'sql'; select tezt0(1); tezt0 --- 3 (1 row) create function tezt1(int) returns ti