Tom Lane wrote:
>
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
>
> > I already mentioned an opinion in 2001/09/08.
> > Both the command counters and the snapshots in a
> > function should advance except the leading SELECT
> > statements.
>
> I do not like the idea of treating the first select in a function
> differently from the rest. And such a rule wouldn't let you build
> guaranteed-stable functions anyway;
AFAIK there has been no analysis where we can get *stable*
functions. As far as I see, we can expect SELECT-only functions
to be *stable* if and only if they are surrounded by SELECT-only
*stable* functions.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/