Tom Lane wrote: > > "Hiroshi Inoue" <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])