Re: SetQuerySnapshot, once again - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SetQuerySnapshot, once again
Date
Msg-id 26344.1024412109@sss.pgh.pa.us
Whole thread Raw
In response to Re: SetQuerySnapshot, once again  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Responses Re: SetQuerySnapshot, once again  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Request for builtin function: Double_quote
Next
From: Tom Lane
Date:
Subject: Re: PostGres Doubt