Re: [GENERAL] Couple of question on functions

On Tue, 13 May 2008 22:51:00 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "Vyacheslav Kalinin" <[EMAIL PROTECTED]> writes: > > Reading the manual recently I came across this: ( > > http://www.postgresql.org/docs/8.3/interactive/xfunc-volatility.html ) > >> Because of the snapshotting behavior of MV

Re: [GENERAL] Couple of question on functions

> You might think it's "likely", but in fact no inlining will happen > because you have a volatile argument that's used more than once inside > the function body. Inlining would change the results. Yeah, right, apparently I overestimated chances of inilining, thanks for the hint, Tom. In fact in

Re: [GENERAL] Couple of question on functions

"Vyacheslav Kalinin" <[EMAIL PROTECTED]> writes: > Reading the manual recently I came across this: ( > http://www.postgresql.org/docs/8.3/interactive/xfunc-volatility.html ) >> Because of the snapshotting behavior of MVCC (see Chapter >> 13

[GENERAL] Couple of question on functions

Hello, Reading the manual recently I came across this: ( http://www.postgresql.org/docs/8.3/interactive/xfunc-volatility.html ) > Because of the snapshotting behavior of MVCC (see Chapter > 13) a function containing only SELECT commands ca