Re: SetQuerySnapshot, once again

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Tom Lane wrote:
>> 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 dt into txt from t where id = $1;
>   return txt;
>   end
>   ' language plpgsql;

I'm not sure exactly what you mean by "stable" here.

And I'm even less sure whether you are arguing for or
against adding SetQuerySnapshot calls into plpgsql...
        regards, tom lane