Re: SetQuerySnapshot, once again

Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > I have a question. Could the functions which contain no
> > queries other than SELECT be stable(returns the definite
> > result for a query) with it ?
> 
> Sorry, I don't understand ...

Let t be a table which is defined as create table t (id serial primary key, dt text);
Then is the following function *stable* ? create function f1(int4) returns text as ' declare txt     text; begin select
dtinto txt from t where id = $1; return txt; end ' language plpgsql;
 

If SetQuerySnapshot is called for the above *select*,
the result isn't determined by the snapshot of the
function.  

regards,
Hiroshi Inouehttp://w2422.nsk.ne.jp/~inoue/