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/